topic Re: Show measure column in a dimension column if dimension value is equal to specific value on pivot table in App Development

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

acgomes — Tue, 30 Aug 2022 20:19:55 GMT

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

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

sidhiq91 — Wed, 31 Aug 2022 03:56:51 GMT

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

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

Timario — Wed, 31 Aug 2022 06:24:17 GMT

Hi.

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

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

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

acgomes — Fri, 02 Sep 2022 21:14:42 GMT

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

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

Timario — Sat, 03 Sep 2022 05:44:41 GMT

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)

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

acgomes — Mon, 05 Sep 2022 11:16:28 GMT

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

Thanks.

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

Timario — Mon, 05 Sep 2022 13:13:01 GMT

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)

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

acgomes — Mon, 05 Sep 2022 13:44:55 GMT

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