Getting a Column SUM in a Chart Table

[aljaztoman]

Dear all,

Is there a way to use a function to get the sum of a specific column in a chart table?

As shown below, the dimension is the different persons, and columnA is a calculated measure for each dimension entity. In columnB I want to get the SUM of the previous column.

Thank you in advance

[tresesco]

Try with TOTAL, like:

Sum (Total Sales)           //assuming your first col expression is 'sum(Sales)'

[aljaztoman]

Hello,

It is actually a very complex calculation and getting a total with a single equation wouldnt work for me, because i have individually set max values for each person - therefore it is necessary for me to somehow reference the actual value in the field of the table.

Kind regards,

[aljaztoman · Accepted solution]

I have found a solution using RangeSum() of the previous column, and then selecting the last field of the new column with top() as the value i want.

Still open for any other solutions.

[Bernice_xjn]

or you can ues :bottom(columnC)