how to show sales difference for current month and previous month based on selection?
I have following table
I want to show sales difference in Text box . if i select march it should show difference from march sales to feb sales,if i select jun it should show it should show difference from jun to may.based on current it should display.please help me.
Re: how to show sales difference for current month and previous month based on selection?
Refer to the attached sample, best way to derive using master calendar and set analysis method, (real time u should have data in date format with historical period so u have to update this expression).