Aggregate Dimensions

[#1]

Hi Everybody,

I want to aggregate the values of a dimension in the following way:

The dimension "item group" has 4 digits with a revenue

- BYDF ==> 100.000€

- BYRK ==> 200.000€

- BYSW ==> 250.000€

What I want to do is aggregate the revenues of these three values to a single-digit item group "B", which sums up the values to 550.000€. "B" should be displayed within the other 4-digit item groups as a dimension.

Thanks for any ideas.

[sivarajs]

Add a calculated dimension as if(Group='BYDF','B',if(Group='BYRK','B',if(Group='BYSW','B'))) or

if(WildMatch(Group,'B*'),'B')

Expression as sum(amount)

[#3]

Hey,

thanks for your quick answer. I already thought about the cascadef if-statement, but it's not the right way. The result should look like this:

- B ==> 550.000€ (the calculated sum of the 3 revenues below)

- BYDF ==> 100.000€

- BYRK ==> 200.000€

- BYSW ==> 250.000€

Best regards

[#4]

I think, you can solve this by using WildMatch function. See the attachment.

[#5]

We are on the right way 🙂 The aggregation works, but I need to display the other 3 four-digit item groups.

[#6 · Accepted solution]

Hi,

I am not able to solve this from chart object level. So, I have made it through the script. Pelase see the attachment.

[#7]

Perfect. Thank you very much!!!