“Show value as” lets you see each number in a pivot table as a share of a total instead of the raw amount. For example, you can see what percent of a month's transactions came from each acquirer or card brand.
-
Open the Menu
-
Right-click any value cell in the pivot table.
-
Select Show value as.
-
-
Choose an Option
-
Select one of the options listed in the table below.
-
The groups shown in gray next to each option tell you which total the percentage is based on.
-
The pivot table will update, and a checkmark will appear next to the option you selected.
-
-
Check the Exact Value
-
Right-click a cell and select Show value... to see its exact value.
-
Values are shown as decimals. For example, 0.25 means 25%.
-
-
Switch Back to the Original Values
-
Right-click a cell and select Show value as.
-
Click the option with the checkmark to turn it off.
-
Options
|
Option |
What it shows |
Example |
|---|---|---|
|
% of grand total |
Each value as a share of the total of all values in the table. |
The share of all transactions in the date range that came from one acquirer in one month. |
|
% of Row |
Each value as a share of its row total across all columns. |
For one card brand, the share of its transactions that happened in each month. |
|
% of Column |
Each value as a share of its column total. |
Within one month, the share of transactions that came from each row. |
|
% of Row Parent |
Each value as a share of the subtotal of the group it belongs to. |
Within one card brand, the share of transactions that were Credit versus Debit. |
|
% of Column Parent |
Each value as a share of the subtotal of its column group. |
Most useful when the table has more than one column group. |
Tips
Percentages showing as 0? Small percentages may round to 0 in the table because the cell keeps its original number format. Use Show value... to see the exact value.
Choosing the right option. Use % of Column to compare groups within a month. Use % of Row to see how one group is spread across months.