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

user09845

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

david_cunningham

@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

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