Hi all,
I would like to ask whether the following is possible.
Basically I have table which has the following data:
Code,
Amount in Curr,
Currency,
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!
Thanks
Keibri