3 Replies Latest reply on Sep 5, 2016 10:25 PM by Mahfooj Khan

    How to create calculated members to be shown in the dimension together with ungrouped values (excel datasource)

    fede tede

      Hello,

       

      I have a dataset with a structure like this:

      Customer
      RegionMeasure
      c1R110
      c2R220
      c3R330
      c4R440

       

      I need to use the Region as filter, but grouping the values... the filter should contain the following values:

      - National (R1, R2, R3, R4)

      - Ra (R1, R2)

      - Rb (R3, R4)

      - R1

      - R2

      - R3

      - R4

       

      How can I achieve this result?

       

      Thanks in advance!