Sum of rows

[absekrafi]

Dear All,

I've created a fact table from many oracle tables using join and concatenate.

I want to use a table area where I selected the relevent dimensions and data.

What I got is :

- The same dimension fields repeated when only data field chenges. (please see the enclosed image).

Only the "Stock non marchand" changes.

I want the sum of these fields instead of the list of fields with different values between two dates.

Note : I tried to use cross tables but the dimensions are limited to 3, so I used table area.

Thank you in advance,

Abdallah

[vishsaggi · Accepted solution]

use straight table and add your dimensions and expression. In the expr tab check the radio button in the Total mode in bottom right below that says sum of rows.