Get Total value from a Table

[#1]

Hello, i have a simple question but i cannot manage to do it..

I have a table with columns: ID , Sales ( value is 1 or 0 )

On the top of the table, there are automatic TOTAL rows which print the good value.

Here comes my issue, i would like to get the Total value and display it in a Text Object for example.

Is it possible to do it?

Thank you in advance

please find attached an example picture, i would like the total value 13 instead of 1515

[#2]

Hi,

FYR

Sum(Total Sales)

Regards,

Sukamal

[#3]

Sales is a new calculated column, so i can't find it from the Text Object 😕

Is there a way to get the Sales expression from outside of the table

[#4]

sum( total [Total Sales])

[#5]

Can you post an example, I will try to fix for you.

[#6]

I still don't have any visibility of my Sales Field

[#7]

Hi,

Then you used aggr function....

it will soved your problem.

[#8]

Get your document uploaded I'll do it for you quickly.

[#9]

Here is the example

[#10]

You're blocking out the column headings which I will need to build the expression. Move the white box so it's covering data only, not the column headings in your example table.