Hi all
I use following formula to calculate our revenue based on users selection.
Num(sum({<Fact.Type = {'Sales'}>}Fact.Net_Rev_EUR), '#''##0.00')
for some other calculations I need the full year figure by ignoring users selection, but it should take only current year and ignore last year.
how can I integrate that?