Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi ,
So my data looks something like this
F1 F2
A X
A X
A Y
B X
B Y
B Y
I want to see occurrences when more than 1 F2 exists for a F1 i used a total function to get this ,
but problem is when i try making the dimensions dynamic by choosing F1 and F2 among F1,F2,F3,F4,F5 and F6 based on button selections, i can't seem to use the calculated expression in the total function
the expression I'm using is if(count(distinct total<F1> F2)>1,red())
i don't seem to understand why it doesn't work for calculated dimensions
This is a color expression?
if(count(distinct total<F1> F2)>1,red())
What are you using as calculated dimension?
Hi Sudip
You could use the AGGR() function instead and check the counts. Something like this.
if(Aggr(Count(distinct F2),F1)>1,Red())