Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
(Sorry in advance, English isn't my primary language)
Hello everyone,
I'm facing a particular issue : I have a pivot table in which the first elements of the Columns part are "Values" from the measures I've added (it was generated automatically) and the second element is a normal dimension "Motif de sortie".
I need to make sure that the columns of my "Motif de sortie" elements hide for some columns of my 1st dimensions (Values).
For example, I have 3 columns of Values : a, b and c and for "Motif de sortie" I have the columns 1, 2, 3
I want b and c to have the columns 1, 2, 3 but not a.
Do you have a solution for this ? I thought about using "Show column if" but I don't know how to select the "Values" element in the expression
You can use this in show column if
=IF(Match(Only([Values]), 'b', 'c'), 1, 0)
In the expression do you replace the "Values" element by something else ?
Because as such, it doesn't work for me