Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys!
I would like to compare the results from the months of the selected year with the previous year.
Is this possible?
I added some more information in the attached document.
Kind regards,
Katleen
Het bericht is bewerkt door: Katleen Vercauteren
Hi,
Try below
Current Year Sales
=Sum({<Year = {'$(=Max(Year))'}>} Sales)
Previous Year Sales
=Sum({<Year = {'$(=Max(Year)-1)'}>} Sales)
Regards
ASHFAQ
Hi,
There is no document attached. Kindly attach again, also give some example of your problem.
Regards,
Kaushik Solanki
Hi,
Try below
Current Year Sales
=Sum({<Year = {'$(=Max(Year))'}>} Sales)
Previous Year Sales
=Sum({<Year = {'$(=Max(Year)-1)'}>} Sales)
Regards
ASHFAQ
Thanks Ashfaq, you've been a great help!