Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can you help me on getting 0 for previous month Sales when selecting month in month filter.
Whenever selecting or changing month in month filter only current month total sales is showing, prev month sales showing 0. If I select 2 months in month filter the both values are showing.
Prev Month-----Sum({< PDate = {">=$(=date(monthstart(Max(PDate),-1),'DD-MM-YYYY'))<=$(=date(monthend(Max(PDate),-1),'DD-MM-YYYY'))"},PDate= >} Sales)
without selecting Month in filter
After selecting month in filter
Try with "Month=" in your set analysis, something like :
Prev Month-----Sum({< PDate = {">=$(=date(monthstart(Max(PDate),-1),'DD-MM-YYYY'))<=$(=date(monthend(Max(PDate),-1),'DD-MM-YYYY'))"},PDate=, Month= >} Sales)
Regards
Antoine
If I add month=,Pdate= then I'm getting some random value as in below image
Actual Prev. value is 113123.7. Can any one help on this.