Pivot table show only certain value under specific column

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?

Tagged:

Best Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • MichelleH
    MichelleH Coach
    Answer ✓

    @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

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • MichelleH
    MichelleH Coach
    Answer ✓

    @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