Allocation Equally

Summary:

Content (please ensure you mask any confidential information):

Hi

I have 10 entities, and 4 sectors. For ex

Entity A Sector 1

Entity B Sector 1

Entity C Sector 1

Entity D Sector 2

Entity E Sector 2

I have an amount in begbalance in fy 24. for ex : 1091063.

i need this to be allocated for entities equally within the sector which is selected by the user.

For ex : if user selects sector 1, then this amount should be distributed equally within entity a,b,c

if user selects sector 2, then this amount should be distributed in entity d and e

Currently sector is an attribute dimension in the entity dimension. I want a function or something to calculate the no of entities relating to a sector.