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.
View solution in original post
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.