topic Re: Straight Table - Multiple Dimension Total in App Development

Straight Table - Multiple Dimension Total

Mak3 — Sat, 14 Aug 2021 15:26:34 GMT

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

Re: Straight Table - Multiple Dimension Total

Kushal_Chawda — Sat, 14 Aug 2021 22:39:06 GMT

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

Re: Straight Table - Multiple Dimension Total

Mak3 — Sun, 15 Aug 2021 05:45:39 GMT

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