Grouping of dimension

Hi guys 


I have a dataset like this:

DimensionValue   -  Measure

1                                  100

3                                 100

6                                 200

9                                 100

12                                500



I want to group the dimension and aggregate the measure per group (for example)


(1,3,12) AS  Group 1 : 700

(6,9) AS Group 2: 300


How can I do this? 


I already tries to create custome members of the dimension (Aggregate({1,3,12})) a.s.o. but I could not display all groups at once.


Pls help me out

2 replies

    • Senior Director of Product
    • Ian_Macdonald
    • 5 yrs ago
    • Reported - view

    Hi Nikos,

    If you are creating the aggregates using the element tree of the dimension, selecting the items you want to group and applying the Aggregate function, then the defined groups should appear in the panel below the real elements. Deselect all the real elements, then check the grouped items you want to appear  in the grid or chart or whatever:


    If you are creating them using the Formulate module, then click on the "Fx" folder icon to display the folder system and navigate to where they were saved, then select the ones you want to appear.

    Hope that helps.


    • Nikos_Volakakis.1
    • 5 yrs ago
    • Reported - view

    Ian Macdonald Thx a lot it helped !

Content aside

  • Status Answered
  • 5 yrs agoLast active
  • 2Replies
  • 61Views
  • 2 Following