Show measure column in a dimension column if dimension value is equal to specific value on pivot table

[acgomes]

Hello,

I have this Pivot Table organized like this, 1 row dimension, 1 column dimension and 3 measures, something like this

	Dimension B Value A			Dimension B Value B			Dimension B Value C
	Measure 1	Measure 2	Measure 3	Measure 1	Measure 2	Measure 3	Measure 1	Measure 2	Measure 3
Dimension A Value X	x	x	x	x	x	x	x	x	x
Dimension A Value Y	x	x	x	x	x	x	x	x	x
Dimension A Value Z	x	x	x	x	x	x	x	x	x

I would like that Measure 3 was only displayed when Dimension B Value is equal to B or C, is that possible?

In other words, I want to hide what is in yellow.

I tried to use the field 'Show Column If' of Measure 3 with the expression below, but I did not manage to make this work. Im my mind, this should be enough.

If( Match([Dimension B], 'Value B', 'Value C') >= 1, 1, 0 )

Thanks

[sidhiq91]

@acgomes  Could you please provide some sample data? I will try to help you out.

[Timario]

Hi. 

For hide, you can use only expression, without if and values after comma.  For example:

Match([Dimension B], 'Value B', 'Value C')

[acgomes]

Hello,

Thanks for the answers. 

@sidhiq91 I attached a .qvf with data that should reproduce the scenario. 

@Timario , unfortunaly, your suggestion did not work or I implemented incorretly in the .qvf attached using the following expression Match(dimensionB, 'valueB', 'valueC').

I need to hide only the column crossed.

rgds

[Timario]

Hello. You can't hide only 1 measure only for ValueA in pivot table. Expression for hide values in measure works for all (valueA, valueB, valueC)

[acgomes]

That is also the impression I had, unfortunatelly. I guess "Show measure if" instead of "Show column if" would be a bit clearer.

Thanks.

[Timario · Accepted solution]

Hi. You can't hide only  measure from Values only for 1 dimension. Expression for hide values in measure works for all (valueA, valueB, valueC)

[acgomes]

Guess I will suggest this as an idea. The measure we are using only make sense to appear for certain values of the dimension. Also, this is not the type of situation where I can make a measure for each dimension value with set analysis (unpredictable and many dimension values).