Straight Table - Multiple Dimension Total

[Mak3]

Level	Dimensions	Sales	Shops
1	COUNTRY	11,84,22,581	19,189
2	STATE	11,84,22,583	34,560
3	CITY	11,84,22,581	23,937
4	STREET	11,84,22,583	38,772

Hi, Thanks for your support!

Having a data structure with Shops across geographies selling different products. But the shop universe is only  19189.

The filed Level gives the unique shops as 19189 when Level=1

In table sum by dimension should be 19189 for 1st Dimension. Using If Dimensionality()=1 and Level=1 work when one dimension, but not on Multiple Dimension. 

Please suggest solution.

Thanks

[Kushal_Chawda]

@Mak3  don't quite understand. What is expected output?

[Mak3]

Hi Kushal,

Happy Independence Day,

The measure should not add rolling up. At Dimension 1, it should give the sum of Level 1 total.

When we have four Dimensions, each should give the total as per Level with respect to each Dimension. The Shops universe is as per Level 1. But SKUs may be sold at all or limited shops. SO when sum by SKUs, total wont be correct.

Thanks