Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i guys,
i want to customize partial sum, in pivot table, is this possibe...
I have a pivot table with three dimension and one expression,
i have negative values in pivot table, and i dont want to show negative values, so i am showing zero instead of negative values..
but my sum is still same, i want to get the sum of only visible value,
is there a way to do that?
Many Thanks
Khan
Israr , do you have a mapping table that defines which account code converts negative to positive and which one disregards negatives ?
You could add a field called 'converter' to that mapping table that is either 0 (disregard negatives) , -1 (convert negatives) , and 1 (leave as is)
Your expression would be
sum ( Value * converter)
-> any records associated to a code that is 0 get a 0 value in details and sums
-> any records associated to a code that is -1 get a positive value in details and sums
-> any records associated to a code of 1 get no change at all
Would this work ?