Imagine I have 10 dimensions and 1 measure.
The dimensions are such items as "Region", "Country", "State", "City", "Zip", "Account Manager"...the measure is sales revenue.
I'd like to create a dataset that has all possible combinations of the dimensions for the measure...
So, for example, I would want an Account Manager's (AM) individual sales revenue. I would also the AM revenue with state included, so I can compare AMs by state. I would also want the AM revenue by state, by country, by region.
Is it possible to have Alteryx determine all the possible combinations of the dimensions and then perform the calculation for the revenue by each of the combinations?