I have percentage data table and when inserted pivot table the grand total is adding up sum of all individual percentages on collating for various catagories. While it should calculate average sum of the items in that table.
Solved by X. J. in 15 mins