Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i want the last 10 months sales.dynamicaly for changing next month also it should be changes dynamically
let me know hoe proceed in set analysis.can i do with max(month) lik that or is there any option
Hi Mahesh
Try Something in your Expression:
Sum({1<Please Write Your Date Field Name Here = {">=$(=MonthStart(Max(Please Write Your Date Field Name Here), -10))<=$(=MonthEnd(Max(Please Write Your Date Field Name Here)))"}>}Please Write Your Field Name Here)
Hope this Helps You.
Hi Mahesh,
Try like this
=Sum({<YearDimensionName= , QuarterDimensionName=, MonthDimensionName=, Date={'>=$(=MonthStart(Today(), -10))<=$(=MonthEnd(Today()))'}>} Sales)
Replace YearDimensionName, QuarterDimensionName, MonthDimensionName with you Year, Quarter and Month dimension names respectively, this will ignore the selections in those columns so that you will get the last 10 month sales even you select any of this.
If you want to get the sales of last 10 months from selected Date/Other dimensions then replace Today() with Max(DateDimensionName)
Hope this helps you.
Regards,
Jagan.