Aggregatuion/Calculation for different groups

Question

Hi all!

Have an issue, need to create some groups and perform aggregation based on the matrix below:

For example Group 1 will aggregates the data with BU number 6888+1411+1360-4920-1402-1310 etc.

Same for Groups 2,3,4.

In the end i need to have four separated aggregated tabs: 3911,3925,2934,3986 based on the coefficients above.

Hope it is not too confusing. Thanks for your help!

dammy file.xlsx

RT4 · Answer

Hey!

Thanks for the fast reply.

I think i forgot to add the allocation matrix.

The idea is to have 4 separated sheets for 3911, 3925, 3934 and 3986.

Each should include unique BU Position, Group_1;Group_2, Group_3 and Group_4 data.

The problem is that each Group has different coefficient depending on which BU they are allocated to.

Hope it is more clear now;)

Regards

Roman

Matrix2.xlsx

apathetichell · Answer

the file you posted looks pretty different than the preview that's up... I get you want to aggregate the data by group - but are there going to be multiple BU_Numbers - or just multiple BU_Positions that you are aggregating by?

dammy file.yxmd