Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a pivot table like:
And I need to show only the names that include "_D_"
I.e. I need to get the following:
Any ideas, plese ?
Thanks a lot in advance!
Either use a calculated dimension, like
= IF (WILDMATCH(Name, '*D*'), Name)
or do something similar in the expressions (and do not show NULL-values):
SUM(IF(WILDMATCH(Name, '*D*'), MyValue))
Peter