Advanced Aggregation

[tedalien]

Hi dear Gurus,

I hope is ok I ask a question. I am trying to solve a problem and I think the best option would be the Aggr function.

In principle I am trying to achieve getting the sums of an higher level of aggregation (Level Dim1+Dim2) to be displayed in each raws of the subsequent level.

Dm1 and Dim3 are limited in number of unique elements, but the Dim2 can be many.

Dim1	Dim2	Dim3	Value Split	I need
AAA	AA	A	5.6	6.9
AAA	AA	B	1.3	6.9
AAA	BB	A	1.8	2.3
AAA	BB	B	0.5	2.3
AAA	CC	O	1.5	1.5
BBB	BB	A	3	16.6
BBB	BB	B	12.1	16.6
BBB	BB	O	1.5	16.6

I tried with:

sum(Total(aggr(aggr(sum(Value Split),dim1,dim2),dim3)) and this works as long as there is one Dim2 selected, when I release the selection the Total is calculated on all Dim1 and Dim2 elements.

I tried some variation but so far no success.

Can you suggest if this is the way (best) or if there is antoher?

In case this is the way, can you help me fixing the set analysis?

Many many Thanks!!

Alen

[tedalien]

Jagan and ALL,

Indeed it does when I load the data as INLINE.

I was misunderstanding your instructions and thought you where suggesting the <dim1,dim2> to be applied to the set analysis not to the TOTAL.

I got itnow and applied to my application with a more complex form seems also working.

More test ti be dine but THANK YOU!

It has been enlightening!

Regards,

Alen