3 Replies Latest reply on Sep 11, 2018 8:31 PM by julian.ramirez.0

    Group values inside dimension

    julian.ramirez.0

      Hi all

       

      I have a database like this

      Bedrooms|Measure

      0|3

      1|10

      2|4

      3|7

      4|0

      5|3

      6|8

      7|10

      What I want is to group the dimension to show all values that has Bedrooms>4 in one called 5+ and the values of Measure must be added to this dimension (so in this case 5+ values must be 21). How can I achieve this? Actually this is what I did but in the field 5+ I can't see the total o that dimension because it's divided by each dimension inside it.

       

      Regards,

      Julián