question (Total)

[nevilledhamsiri]

I have done a calculation on fixed value after loading tow tables of which this cell was considered as an absolute cell reference.But once I brought this in to a pivot table, total doesn't appear as 100%. I may present my case as below:

Class_Code               Amount          Percentage (Taken through a formula)

MC                             500               10%

FR                              2000              40%

TC                              1000               20%

M3                              1500               30%

Total                            5000                100%  (Once data are loaded in pivot table, total % as 100 is not appeared).

Please explain how this will be obtained

Thanks

Neville

[ecolomer · Accepted solution]

Is this you need

[nevilledhamsiri]

I need 100% to appear in last row of percentage column!

[ecolomer]