Filter to get Partial sums from tables

[#1]

Hi community,

I have 4 pivot tables, each have different expressions but same dimensions to show totals. Now I need a filter that shows partial sums in all the pivot tables.

Example:

Pivot 1 total = 456123. Pivot 2 total = 789546. Pivot 3 total = 956234. Pivot 4 total = 753159.

Now I need a list box with values 10%, 20%, 30%, 40%  all the way to 100%, if the user selects 10% all the totals in the pivot tables must show 10% of the total value.

Any suggestion is Hugely appreciated.

Thanks,

Larry.

[vinieme12]

please post a sample app