Pivot Table

Occasional Visitor

I would like to get your help in PIVOT TABLE grand total option. I am stuck to resolve the issue, I want the average rate of total amount & total nos. which should be 26.42 but it shows 27.19, will you please help me out, I will be very thankful to you. The picture is appended below for your understanding.


1 Reply
Hi @Sajj_Zee - So sorry to hear you are struggling with Excel functionality. This forum is specifically for Microsoft Viva, which is the new employee experience platform. May I recommend that you post your question to our Answers forum for M365 and Office? https://answers.microsoft.com/en-us You will get a better response there.