Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can Anybody help me to find a solution 4 this problem i am facing here with my current project.
Scenario :
I am having sales amount based on month selection like it i select jan /feb /mar......... i will get correct data for my current selection,but my requirement is that ,i need 2 more selection like previous month ,previous-1month for that i should select only one Month .
that month can be Jan,Feb,Mar.......
if i select month of 'Feb' then i should get data for ,Jan and Dec automatically by selecting only on 'FEB.
if i select month of 'jan' then i should get data for ,Dec and Nov automatically by selecting only on 'JAN
if i select month of 'Jul' then i should get data for ,JUNE and Jul automatically by selecting only on jUL
if i select month of 'Mar' then i should get data for ,feb and jan automatically by selecting only on 'MAR'.
i tried it by using set analysis but i was not able to find the solution .
Please suggest me any method which uses Current selection or Get selected Value.
I need this solution very urgent.............
Thankx in advance......
Plz reply me on.... dushyant@iconresources.com
Dushyant
Do you have variables for your month or are you using fields ? You can try following
Sum({<Month={$(=Only(Month))}>} Sales) for current selected month
Sum({<Month={$(=Only(Month) - 1 )}>} Sales) and
Sum({<Month={$(=Only(Month) - 2 )}>} Sales)