Pivot tab not giving correct results when dimension added as Column

twinklea — Thu, 11 Jul 2019 11:10:58 GMT

Hi,

I have a pivot table which is behaving weird in providing the results:

Below are the 2 formats:

Quantity	Month-201908
Capacity	7407999

Quantity, Month-201908
Capacity	1852000

In the first table, i have added Quantity as Row and Month as Column. Quantity is an inline dimension which contains Capacity as one of its records to which the KPI is linked ( if Quantity ='Capacity', sum(Capacity)) whose value is actually 1852000 for Month 201908 but it is showing correctly only when i keep both dimensions Quantity and Month in the Row.

As though, it gets like expanded view from Quantity to Month level.

Not sure , the value 7407999 is coming from where but I want to add Quantity in Row and Month in the Column..

Can some one please tell me whats going wrong here ?

topic Pivot tab not giving correct results when dimension added as Column in App Development

Pivot tab not giving correct results when dimension added as Column