YTD problems - already checked out 10 examples...

[#1]

Hi all,

I have tried all the options and I had a few successes with this, but unfortunately I can't find the answer to my problem.

I am trying to make a chart with YTD (In PIVOT table layout). However, the functions do not work properly. Whichever one I try

See attached example

Thanks in advance for your help!

[pover · Accepted solution]

Try the following function in your pivot table

rangesum(before(sum(OMZET),0,12))

Set analysis doesn't work when the set anaylsis is done over fields that are defined as dimensions.

Regards.

[#3]

PERFECT !!! I think this will work!