Forum Discussion
UmarNayab
May 11, 2023Copper Contributor
How to Add Grand Total in Pivot Chart Colum Bar ?
Hi Experts, I have a scenario in pivot, Which goes as below, Region Count A 1 B 2 C 3 Grand Total 6 Now i...
- May 12, 2023
Maybe this: a calculated item and and some creative formatting.
UmarNayab
May 11, 2023Copper Contributor
Hi Patrick, Thank You for your reply.
Tried As mentioned below, unable to get desired output. Kindly check on screen shot attached. I am missing something... Please Advise
Patrick2788
May 12, 2023Silver Contributor
It looks like you're using a Calculated Field rather than a Calculated Item. If you're able to attach the workbook, I can take a look.
- UmarNayabMay 12, 2023Copper Contributor
Hi Patrick2788 ,
Sure, Attaching Excel sheet for same. ( Sample Sheet just to get idea on this concept, to apply on main report)
- Patrick2788May 12, 2023Silver Contributor
Maybe this: a calculated item and and some creative formatting.
- UmarNayabMay 12, 2023Copper ContributorGot It! Thank you so much Patrick! You've been very kind and helpful.
Thanks once again, Good Day! 🙂