Pivot Table - Gives False Sum

[psk180590]

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.

[Anonymous · Accepted solution]

try this as expression:

sum(aggr(if(count(VisitID)>=1,1,0), %Key_Company,Code,Date))