I would like to ask whether the following is possible.
Basically I have table which has the following data:
Amount in Curr,
Amount in Local Curr
I would like to create a pivot which shows a multiple column total:
-Grand Total in Currency
-Grand Total in Local Currency
For convenience I have attached the excel and highlighted in yellow would I would like the pivot table to include.
Thanks a lot for your kind help!