0 Replies Latest reply: Dec 29, 2012 6:29 AM by Vinod Kesharwani RSS

    If and Set Analysis in combo chart

      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...