Customize Partial Sum...

[israrkhan]

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

[JonnyPoole]

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 ?