Previous Topic Next Topic

Pivot Table Query

Closed
tyrone - May 20, 2010 at 04:01 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 20, 2010 at 07:19 AM
Hello,
If I construct a pivot tables that looks as follows :

Name Total Current 30 Days 60 Days 90 Days
Mr Jones 5000 1000 0 500 3500
Mr Smith 1000 0 500 500 0
Total 6000 1000 500 1000 3500

Is it possible to insert percentage fields as follows :

Name Total Current 30 Days 60 Days 90 Days
Mr Jones 5000 1000 0 500 3500
100% 20% 0% 10% 70%
Mr Smith 1000 0 500 500 0
100% 0% 50% 50% 0%
Total 6000 1000 500 1000 3500
100% 16.6% 8.3% 16.6% 58.3%

Thank you for your help!




1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 20, 2010 at 07:19 AM
I am not expert with pivot table, but I dont think it is possible to do so directly. It has to be done in some other creative way, like adding a row to the data that has these %ages.
0