Dimensionality

[#1]

Hello,

I need to use the sub-total of a column in a calculation for a new column. I have tried using dimensionality but it isn't working as I want it to. The last column in the image below is Expected Contribution. The column I need to create is Actual Contribution which would be calculated by saying the Sales per Salesman / the sub-total of the Warehouse the Salesman is grouped under.

For the image below, it would be 82 / 165 and then 83 / 165.

Thanks for your help in advance,

Shane

[lironbaram]

hei

attach is an example of what you asked for

you calculate the sub total in the expression

[#3]

Roi,

Thanks. I've adapted it though and it's not working. I've attached a sample. I would really appreciate it if you could have a look at it and tell me where I'm going wrong.

Thanks,

S

[lironbaram · Accepted solution]

hei attach is the sample working

you cant do a applay total when you use a column name

i change it to the actual formula have a look

[#5]

Roi, thank you for your time. It's 100%.