using calulated dimension in total functions

[Anonymous]

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

[sunny_talwar]

This is a color expression?

if(count(distinct total<F1> F2)>1,red())

What are you using as calculated dimension?

[ychaitanya]

Hi Sudip

You could use the AGGR() function instead and check the counts. Something like this.

if(Aggr(Count(distinct F2),F1)>1,Red())