4 Replies Latest reply: Feb 1, 2016 5:19 AM by Riccardo Schillaci RSS

    Set Analysis Compare Number with Range Classification

    Riccardo Schillaci

      Hi all,

       

      I have a Pivot table with a dimension and N measures...

       

      I want to match a Measure number "VALUE" with an EXCEL loaded with many rows as are the ranges with RANGE_FROM, RANGE_TO numbers.

       

      I have a set analysis like this: sum({<VALUE={">=RANGE_FROM<=RANGE_TO"}>} RANGE_VALUE) but it doesn't work.

       

      Can anyone help me?

       

      Thank you very much, best regards.

      Riccardo