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 ?
