Only show above dimension when duplicate

Femke_DPG — Thu, 09 Jun 2022 12:39:34 GMT

Hi experts,

I only want to see the name of the payer (in black to anonymiser)

If the 2th dimension has the same value as the 1th, it shows null() because I installed it that way. That's quite ok, but I want to not see the '-' either.

So I want to see the first and second dimension when the 2th is different and only the first dimension when the 2th is the same.

In fact, here I want to show only the black rows.

When I untick 'Include null values', it only shows this, so the rest disappears:

Thank you for helping me on this!

Appreciate your help

Femke

Re: Only show above dimension when duplicate

vinieme12 — Mon, 13 Jun 2022 09:12:00 GMT

Why not just change the Text Color to White for Dimension2?

=if(Dimension1=Dimension2,white(),black())

topic Re: Only show above dimension when duplicate in App Development

Only show above dimension when duplicate

Re: Only show above dimension when duplicate