7 Replies Latest reply: Nov 27, 2017 11:41 AM by Antonio Forino RSS

    Set Analysis with selected values

    Antonio Forino


      i'm using this set analysis.

      Basically i would like to select Month and Year, and then have a graph showing Month and Year based on other fields (Month_Surgery and Year Surgery)


      =Sum({<Invoice_Date_Num=,Month_Surgery={$(=Concat(Chr(39) & GetFieldSelections(Month) & Chr(39), ','))}, Day=,Year=,Month=,Year_Surgery={$(=Concat(Chr(39) & GetFieldSelections(Year) & Chr(39), ','))}>}WI_EUR)

      This formula is working only if 1 month is selected - i would like to have graph also if more than one month is selected.

      How i can do this?