Pivot Table - Gives False Sum

psk180590 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Pivot Table - Gives False Sum

Anonymous — Wed, 19 Sep 2018 09:07:27 GMT

try this as expression:

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