Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i am using before function in pivot table with 3 dimensions. My expression is as below
if(columnno()=1, Sum(Qty), Before ([inv])) --inv is one of my expression
When i select some values in the dimension am getting proper values as per the expression defined. But without selection am not getting the values proper, giving some random.
How do i get without selection.
Thank you!
-Sivaraj
Would you be able to share an image with and without selection?
Thank you for your reply
i have just pasted a sample here,
when i select source 165A,
Source | Planmonth | 201609 | 201610 | 201611 | 201612 | 201701 | 201702 | |
165A | hand | 20000 | 20500 | 21700 | 22180 | 23180 | 27200 | |
offset | 500 | 1200 | 480 | 1000 | 4020 | -100 | ||
inv | 20500 | 21700 | 22180 | 23180 | 27200 | 27100 |
when i dont select somewhere i get right values but not proper
Source | Planmonth | 201609 | 201610 | 201611 | 201612 | 201701 | 201702 | |
165A | hand | 20000 | 35000 | -14000 | 22180 | 23180 | 12000 | |
offset | 500 | 1200 | 480 | 1000 | 4020 | -100 | ||
inv | 20500 | 36200 | 22180 | 23180 | 27200 | 11900 |
when i dont select somewhere i get right values but not proper
What do you mean? that the values are right but not proper? What is proper?
In 2nd table, i have not selected source 165A, for some months am getting before values of inv is correct for some other it's not correct