Expression to return value of a single dimension item in a seperate column

[zakpullen]

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.

[sunny_talwar · Accepted solution]

May be try this

Sum(TOTAL <DIM2> {<DIM1 = {'Company'}>} Score)

[zakpullen]

Perfect!

Thanks as always.