Category based on ratios

[BRRLL99]

Hi 

I have following scenario

Each Line item must categorize under 1 head name – AU name.

AU name to be identified based on profit centre code.

For ABSE having “Share or Shared or Sharing” shall be categorized as Shared in AU name

e.g., S12 shared, S17 shared, S4 shared, S1 shared please refer below notes for ratios.

All line items categorized under “Shared” shall be allocated based on agreed ratios to respective AU’s

sample file has been attached

[binuacs]

@BRRLL99 your requirement is not very clear, can you give some clarity on your requirements? would it be possible to upload the expected result? 

[BRRLL99]

there is no expected result

just instructions and data

could you please check