Getting totals from straight table

[#1]

Hi Guys,

I've got one stupid question to ask, but I have to do that.

Is that possible to get total sum of rows from straight table and use it somewhere else? I'm trying to create a text field with sum o f two sums from different objects. I'm using expressions from the straight tables, but I can't get proper values from the second one (because expressions are complicated). I know here should be to have the expressions working. I'm just asking.

Please see my attached image where I put what I need. Thanks in advance for any answer.

Regards,
Paweł

[jonasheisterkam]

You can use a macro but this must run every time the table change.

Have you look for aggr()-function to build the value outside the diagram?

[preminqlik]

sum(aggr(<Expression>,Dimension1,dimension2))

[vipin_mishra479]

hi

please attached some sample

[#5]

Hi Vipin,

Could you please attach your file again?

Thank you in advance.

Regards,

Paweł