Pivot Tables - show payments per currency

adam97 From the PivotTable Field list (the sidebar of all your fields), you can click on the value for a list of options and select "Value Field Settings". From there, under the "Show value as" tab, you can change the value from currency to a calculation "% of grand total"

The tricky part i have found is if you want to show the total amount in currency format, in addition to the % of the total. I have found the best way to do this is adding your data to a data model. Sounds complicated, but super easy. Try the following steps:

1. Convert your data to a table (Select all data, then click CTRL+T)

2. Create Pivot Table (Insert tab, Pivot Table). Wen doing this, check the box that says "add this data to the Data Model"

3. Add your total amount paid (or whatever your naming convention is) to the value field of your pivot table. 

4. Duplicate step 4 (the data model allows for multiple value in the value field. On the 2nd value you add, click on the value and select "Value Field Settings". 

5. With the value field settings tab open, select the "Show value as" tab and then select "% of grand total" from the drop-down list. 

Hope this helps.