Let pivot table ignore other selections

[#1]

Hi,

Im using an OnOpen trigger to change the selection in the current year. But i have a pivot table that must show data from other years, can i let the pivot table ignore the selections that are made?. The dimension used is called FACTUURNUMMER and it has the following expression:

if(EUR_TOT_BEDR_OPVOER > 0,  today() - FACTDATUM)

Somebody know a solution?

[#2 · Accepted solution]

Already solved it with the following:

sum

({$<DIENSTJAAR= >}if(EUR_TOT_BEDR_OPVOER > 0, today() - FACTDATUM))