Hi,
I have a table in my application where I don't want to show a column if I have duplicate values, but where I do want to show them if these values are different. I have created a simple example below.
The fields Depot country, Material Group and Price will always show
Now if we select only DE, I would like to see the table including customer without material. Because for different customers, we have different prices. But all the prices of all materials within one group are the same.
If we select BE, I would like to see the material, because we have different prices for the materials within one material group.
I tried with putting this formula in the 'show column if'. But only seems to work for the customer and not for the material or both.
avg(aggr(Count(Distinct Price),[Depot country],Material, [Material group]))
>
1
Would you have any idea if this is possible to solve?
Many thanks in advance,