My If Condition and Set analysis is not giving me correct result.
Scenario:
I have a Combo chart with Actual Current year, Actual Previous Year and Budget Currect Year with Month dimension. Also I have selection in year and month.
i would like to show, if user select Year then chart will show (This is done) but when I am selecting month it is applying the filter condition on Month in chart, but i don;t want that. I want that If user is selecting Month then chart will show for entire month (Jan,Feb,mar,Apr...) data in chart,
My Calculation is:
If (Banca = 'Total Bank', SUM ({$<Month=, Code {1,2,3,4,5,6}>} Acutal_Amount),
if (Banca = 'Sector Bank', Sum ({$<Month=, Code {1,2,3,4,5,6,7,8,9,}>} Acutal_Amount),
if(Banca = getfieldselection(Banca), Sum ({$<Month=>} Acutal_Amount)
)))
by using the above calculation filter is applying in month. but I do not want that. Is there any way to restrict this thing rather then Different State.
Please help...