illusionek
Board Regular
- Joined
- Jun 21, 2014
- Messages
- 104
Hello
I have a simple PowerPivot table with the following columns/split:
1. Month
2. Store Name
3. Product Category
4. Qty Sold
I am trying to calculate % of tota sale by product category for each store and I keep getting errors. I want to calculate that for example Product 1 was 30% of total sale in Store 1 and perhaps 10% of total sale in Store 2. Unfortunately I end up with calculation as % of the total sale across all stores rather than for each particular.
I tried various combinations of ALL() and ALLSELECTED() and nothing is working.
Any help please?
Many thanks!
I have a simple PowerPivot table with the following columns/split:
1. Month
2. Store Name
3. Product Category
4. Qty Sold
I am trying to calculate % of tota sale by product category for each store and I keep getting errors. I want to calculate that for example Product 1 was 30% of total sale in Store 1 and perhaps 10% of total sale in Store 2. Unfortunately I end up with calculation as % of the total sale across all stores rather than for each particular.
I tried various combinations of ALL() and ALLSELECTED() and nothing is working.
Any help please?
Many thanks!