Sum columns in table

[#1]

Hi Forum,

I have a straight table, with a column that is calling a variable, that has a complex calculation.

It works great, and sums it up at the bottom (Total Mode). which is what i want.

Now i want to use the "Total at the bottom" in another function in a column.

So

Prod Sales Sales / Units
XXX 1000 1/6
YYY 5000 5/6
TOTAL 6000

Ideas? without using sum( total field) since the current "Sales" function is complex.

[vgutkovsky]

Bernard,

So you want to do a sum of rows and show the results on the bottom row? You can set "sum of rows" in the Total Mode in the Expression tab and then move the total to the bottom in the Presentation tab. Unless I'm misunderstanding something...?

Regards,

[#3]

hi Vlad,

Very close. I want to use the "sum of rows at the bottom" in another calculation. I have the "Total Mode" set for column1 and I get the bottom row Total. In the next column, column2, I want to use the "Total from the 'Total Mode" from column1 for all the rows.

Thanks,

bernard

[vgutkovsky]

Ah, sorry, now I get it. Use advanced aggregation. You mentioned that your expression is in a variable, which I'll call vExpression, and your dimensions Dim1 and Dim2. To use the total from the chart, use sum(aggr($(vExpression),Dim1,Dim2))

Cheers,