Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Try with TOTAL, like:
Sum (Total Sales) //assuming your first col expression is 'sum(Sales)'
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,
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.
or you can ues :bottom(columnC)