Is there a way to conditionally show a column in a pivot table chart

Options

I would like to only show a column for pivot table column based on specific criteria. For example we are showing training courses but I only want to show the number of employees for training 1 and not training 2. I'm using a pivot table chart. Attached is an example

Best Answer

  • david_cunningham
    edited May 28 Answer ✓
    Options

    @user09845

    You could filter the column to exclude "In Scope" for all except for Training 1.

    case when Order Status != 'Completed' and Lead Source = 'Sales' then 'Exclude' else 'Include' end
    

    For example above you can see we have "Marketing","Organic", and "Sales" listed for both "Completed" and "In Progress". Once we filter to only "Include". We get the following results.

    Now, "Sales" is excluded from "In Progress", but left in "Completed". You can use this as a base and swap in your columns and adjust to get your desired output.

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

Answers

  • david_cunningham
    edited May 28 Answer ✓
    Options

    @user09845

    You could filter the column to exclude "In Scope" for all except for Training 1.

    case when Order Status != 'Completed' and Lead Source = 'Sales' then 'Exclude' else 'Include' end
    

    For example above you can see we have "Marketing","Organic", and "Sales" listed for both "Completed" and "In Progress". Once we filter to only "Include". We get the following results.

    Now, "Sales" is excluded from "In Progress", but left in "Completed". You can use this as a base and swap in your columns and adjust to get your desired output.

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**