Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need a column in a straight table that shows the expression value of one of the dimension items. This will be used as a comparator.
For example, I would like the Company score to appear in the Company column against each Unit (not worried about Company rows as present). I've been playing around with different set analysis options, but just can't get it. The Score column is just a basic sum.
Thank you.
May be try this
Sum(TOTAL <DIM2> {<DIM1 = {'Company'}>} Score)
Perfect!
Thanks as always.