Pivot Table

%3CLINGO-SUB%20id%3D%22lingo-sub-2531714%22%20slang%3D%22en-US%22%3EPivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2531714%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20would%20like%20to%20get%20your%20help%20in%20PIVOT%20TABLE%20grand%20total%20option.%20I%20am%20stuck%20to%20resolve%20the%20issue%2C%20I%20want%20the%20average%20rate%20of%20total%20amount%20%26amp%3B%20total%20nos.%20which%20should%20be%2026.42%20but%20it%20shows%2027.19%2C%20will%20you%20please%20help%20me%20out%2C%20I%20will%20be%20very%20thankful%20to%20you.%20The%20picture%20is%20appended%20below%20for%20your%20understanding.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.