Grouping of dimension
Hi guys
I have a dataset like this:
DimensionValue - Measure
1 100
3 100
6 200
9 100
12 500
etc.
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
-
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.
Ian
-
Ian Macdonald Thx a lot it helped !