total calculation

[Anonymous]

hi folks,

how cani achieve 100+400+200+300

object is straight table

dim : country

country    revenue

1              100

2              200

3              300   

4              400

[kaushiknsolanki]

Hi,

     All you have to do is just Go to properties of straight table -> Expression -> Click on Expression -> Total Mode -> Select Expression Total.

     If you want a new column as overall total then you can add expression as Sum(Total revenue)

Regards,

Kaushik Solanki

[swuehl]

Have you tried just creating a chart with dimension country and an aggregation function as expression:

=sum(revenue)

check Total mode: Expression total in expression tab is enabled (or sum of rows, depending on your needs and data model).

Hope this helps,

Stefan