Pivot table - remove sub dimension value

[joeybirdsx]

Hi

i have a pivot table with main dimension is 'Recipe' and Second Dimension (sub dimension) is 'ingredients'

is there a way of excluding showing a sub dimension value 'eggs' in the pivot - by dimension expression ....  without changing the measure expression  

please advise

[Aditya_Chitale · Accepted solution]

Is this what you wanted ? Tried using sample data

Data:

Output:

Expression used for dimension:

=if(ingredients='eggs', null(), ingredients)

Uncheck null Values option in dimension after applying this expression

Regards,

Aditya

[joeybirdsx]

That is fantastic thank you x

Regards 

[G3S]

Hi Aditya, just out of curiosity, if the requirement was to exclude any recipe that had eggs as ingredient, would it be done thru set analysis? 

or does script need to have a group by ingredient ?

[Aditya_Chitale]

@G3S ,

You can achieve this using set analysis with E() function.

Expression : 

sum({$<Recipe=E({1<ingredients={'eggs'}>})>}count)

Output:

Regards,

Aditya