To use the slicer axis to limit results:
Paste the query into the MaxL Shell and run it, as described in Exercise: Running Your First Query.
Note the results in one of the data cells; for example, notice that the first tuple, ([100-10],[East],[Sales],[Qtr1]), has a value of 5731.
Add a slicer axis to limit the data returned to budgeted values only.
SELECT
CrossJoin ({[100-10]}, {[East],[West],[South],[Central]})
ON COLUMNS,
CrossJoin (
{[Sales],[COGS],[Margin %],[Profit %]}, {[Qtr1]}
)
ON ROWS
FROM Sample.Basic
WHERE (Budget)
Results: You should see different results for the queries listed in step 1 and step 3.