How show in Dimension, ONLY CLIENTS for which exist revenues

[#1]

I have a straight table with:

Dimension:          Expression              Expression

CLIENTS             Total Revenues        Revenues only with Salesgroup A

Currently because I have an expression for Total Revenues, I'm getting the full list of clients in the dimension.

I'd like to list only CLIENTS which have revenues with Salesgroup A.

Is there a way to do this with set analysis in the Dimension?

Thanks in advance!

H

[Gysbert_Wassenaar · Accepted solution]

You can use a calculated dimension. Something like:

if(aggr(sum({<Salesgroup={'A'}>} Revenue),CLIENTS)>0,CLIENTS)

Change Salesgroup, Revenue and CLIENTS to the names of your fields.

Enable the option Suppress When Value Is Null for the calculated dimension.

[Anonymous]

Hi,

   Can You please provide Sample Data.

Regards

[#4]

Thank you!