Pivot table show only certain value under specific column

jrtomici · 2023-05-09T19:22:07+00:00

There was an error rendering this rich post.

Hi, I have a pivot table with different media types as columns, and 2 types of values, instances and revenue. I only want to show sum of revenue under TV media type, and only sum of instances under Internet media type. Is this possible with one chart?

Find more posts tagged with

Table

Accepted answers

GrantSmith

You can select the type of aggregation for a pivot table or table with subtotals under the Subtotal options for each column you include and toggle whether to show the subtotal or not.

MichelleH

@jrtomici This is not possible using a pivot table, but you could replicate the same logic by switching to a mega table and creating a separate beast mode for each value column you want to show

All comments

GrantSmith

You can select the type of aggregation for a pivot table or table with subtotals under the Subtotal options for each column you include and toggle whether to show the subtotal or not.

MichelleH

@jrtomici This is not possible using a pivot table, but you could replicate the same logic by switching to a mega table and creating a separate beast mode for each value column you want to show