Attach workbook here.
You can add calculation based on action trigger - like this and create sheet
if [Action (MONTH(Order Date))] then DATEADD('month',-1,[Order Date]) END
When i select june 2017 in first sheet then it will show in second sheet with may 2017 data.
How can I pass the action filter field? I mean can you please explain in detail?
Thanks in Advance
Once action triggered then go to that sheet and see in filter. one action filter avail there. just drag that into calculation and do what i added.
If you attach workbook then i can check now.
Just see my attached workbook.
The calculation that you have given provides us just the histogram, but we are not getting the value for the previous month but the present month.
Could you please help in that?