Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is this you need
Is this you need
I need 100% to appear in last row of percentage column!