Pivot tab not giving correct results when dimension added as Column
I have a pivot table which is behaving weird in providing the results:
Below are the 2 formats:
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 ?