Hi all,
I have a follow up question on the above.
I have implemented the formulas to cut off TOTALMTD Last year. Workes fine in my visual
Now, when I turn the visual back into a table, it will look like this;
Now, I actually need to calculate with the latest value this year vs last year.
In the example €909660 vs €982578
Looking at the totals, the lastdate filter on the list has no influence on this total.
It has probably to do with the granularity of the report (filter by year and/or month)
How can I manage beeing able to calculate with the max value last year when the granularity of the report is not date but month
thanks
Juno