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

user09845
user09845 Member
in Charting

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

Screenshot 2024-05-28 180851.png

Best Answer

  • david_cunningham
    david_cunningham Coach
    edited May 2024 Answer ✓

    @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
    Screen Shot 2024-05-28 at 5.27.59 PM.png

    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.

    Screen Shot 2024-05-28 at 5.29.09 PM.png

    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
    david_cunningham Coach
    edited May 2024 Answer ✓

    @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
    Screen Shot 2024-05-28 at 5.27.59 PM.png

    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.

    Screen Shot 2024-05-28 at 5.29.09 PM.png

    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! ✔️**

Categories