topic Getting a Column SUM in a Chart Table in App Development

Getting a Column SUM in a Chart Table

aljaztoman — Thu, 27 Jun 2019 12:21:24 GMT

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

Re: Getting a Column SUM in a Chart Table

tresB — Thu, 27 Jun 2019 12:26:05 GMT

Try with TOTAL, like:

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

Re: Getting a Column SUM in a Chart Table

aljaztoman — Thu, 27 Jun 2019 13:15:21 GMT

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,

Re: Getting a Column SUM in a Chart Table

aljaztoman — Fri, 28 Jun 2019 10:56:48 GMT

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.

Re: Getting a Column SUM in a Chart Table

Bernice_xjn — Fri, 21 Aug 2020 07:57:42 GMT

or you can ues :bottom(columnC)