Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I'm facing a very strange problem with a Pivot Table.
Without Selection:
After Selecting the Date:
As seen above, the Visit Count increases from 1 to 4 after selecting the particular date.(4 is the correct value present in my DB)
The Formula i have used to get the Visit Count :
sum(aggr(if(count(VisitID)>=1,1,0), %Key_Company))
I have Date and Code as Dimensions.
TIA!!
Sai.
try this as expression:
sum(aggr(if(count(VisitID)>=1,1,0), %Key_Company,Code,Date))
try this as expression:
sum(aggr(if(count(VisitID)>=1,1,0), %Key_Company,Code,Date))