Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello!
aggr(sum(Values)/sum(TOTAL Values),ColumnA)
Works a charm.
Thanks for that