Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am looking for a table that gives me the sum of sales and in another column the sum of M-1 sales. I have a result with rangesum and above, but if I select a Date it's no more working.
Dimension : Date
1st Measure : sum(Sales)
2nd Measure : I try Sum({<[Date.autoCalendar.Date]={"=$(vMONTH)"}, Date=>}Sales) with vMONTH :addmonths(Date, -1) / sum({<Date={"=Date(Date-30, 'M/D/YYYY')"}>}Sales)--> Not working,
Exemple :
10 juin 2022 / Sales : 100
10 juillet 2022 / Sales 145 / SalesM-1 : 100
Thanks for your help !
Use the chart function ABOVE. Above(Sum(Sales))