RangeSum and Above Functions : Cumulative percentage in Pivot Table

[#1]

Hi All,

I have a Pivot Table which shows the creditors which a clerk is responsible for processing. See below:

The column '%' shows the overall percent of volume ('Total' column) which the clerk processes. This can be illustrated in the screenshot below:

E.g. GS processes 11% of the total accounts payable creditors etc..

What I want to show in the 'Test' column, is the cumulative % for the processor. In the first screenshot, the 'Test' column shows cumulative of the 'Total' column. Instead, I want this to accumulate to 100% per processor.

The formula I am currently using is : Rangesum(above([Test]),[Total])

How do I change this to a percentage?

Thanks

[tresesco]

If i have understood your problem, you might be desiring to display the total percenatge to be displayed same for all the subfields under a certain processor. if it is so, give a try using the keyword 'Total' with your Rangesum() function.

regards, tresesco