No/Incorrect totals in Pivot table

[Anonymous]

I have a Pivot table (see screenshot), but the totals are incorrect.

The numbers in the tabel calculated with the extression:

if([Start op]<[PERe.autoCalendar.Date],if([Geannuleerd per]>'0',if([Einde contract op]<[PERe.autoCalendar.Date],0,1),1),'0')

-[PERe] is from a tabel with the end-dates of every month

- [Geannuleerd per], [Einde contract op] and [Start op] are all date-fields

This results in a 1 (one) of 0 (nul) in the tabel.

I can only turn [Show totals] on or off. And they are turn on for [Memberschip]  and [Lidmaatschap ID].

Even with only one dimention (Membership or Lidmaatschap ID) I don't get any totals.

[Marco · Accepted solution]

Hi,
add "Sum" in expression:
Sum(if([Start op]<[PERe.autoCalendar.Date],if([Geannuleerd per]>0,if([Einde contract op]<[PERe.autoCalendar.Date],0,1),1),0))

[Anonymous]

Tnx, that did the trick.

Expressions are still a bit of a challenge for me. Every . and , counts. I'm realy familiar with Excel, but learn every day on Expressions. Realy need to get started with that training for Expressions.

Tnx again.