2 Replies Latest reply: Jan 21, 2016 5:13 AM by Manish Kachhia RSS

    Comparing fields in SetAnalysis

    Andrea Masciulli

      Good morning
      where to use the expression in a Setanalysis should make a comparison between two fields
      I'll explain the formula that I wrote
      if the second operator specific month the formula works

      Sum ({1 <[MeseSerie] = {'January'}>} [Sales]) / 1000000
      but if I have a field Meseselezione not know how to put it in the second operator I tried with:
      Sum ({1 <[MeseSerie] = {[Meseselezione]}>} [Sales]) / 1000000


      but it does not work :-(


      thanks


      Andrea