Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I get overlap ?
if(rowno()=0,
sum( Aggr(count( Distinct Measure),Dimension))- Count (DISTINCT Measure), Count (DISTINCT Measure))
For example in below screenshot
Overlap = 33-13= 20
Try this?
if(Dimensionality() = 0,
sum( Aggr(count( Distinct Measure),Dimension))- Count (DISTINCT Measure), Count (DISTINCT Measure))
Dimensionality()=0 or rowno()=0 =>one or the other will give same.
"sum( Aggr(count( Distinct Measure),Dimension))- Count (DISTINCT Measure)" this is what not working!
So what is that you are seeing there? No value? Can you share some sample data to work on?