Calculated dimension

[bobbydave]

I have an expression that does what its meant to do but I would like to change this to a calculated dimension as it would make more sense.

ColumnA	Values
A	11
B	17
C	19
D	21

My current expression is

sum(values)/sum(total(values)

but I want to change this into a calculated dimension.

Any ideas?

Keep getting 'error' for what I am trying to do. Works fine as an expression but I am changing the design of the table and would prefer to have as a calculated dimension instead.

Thanks                        

[pokassov · Accepted solution]

Hello!

aggr(sum(Values)/sum(TOTAL Values),ColumnA)

[bobbydave]

Works a charm.

Thanks for that