How do I use "Show value as" in a pivot table?

“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.

  1. Open the Menu

    • Right-click any value cell in the pivot table.

    • Select Show value as.

  2. 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.

  3. 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%.

  4. 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.