How do I get the total of sales?

Q&A
, ,
1

Hi everyone.

This is my actual table agent sales I would like to create a calculation sum of the total sales of my agents and add to a third column. It needs to be a calculated field to use it for multiple porpuses.

image
image779×395 59.9 KB

It is possible?

1 Like
2

Hi @gfactorbi,

If you want the same total to show in every row of the Total column, you can use this calculated field:

sumOver(Sales, [], PRE_AGG)
1 Like
3

It work’s. But just for 2 rows:

image
image787×392 42.5 KB

4

Did you choose min as the aggregation in the Value field well?

5

I forgot that. It work now. Thanks!!!