Sum up the rows of the table from another table

[udaya_kumar]

Hi,

I have two straight tables in front end.

I have few calculated fields in both the tables. I want to sum up the rows of an expression "Expression1" from table1 in table2.

I want to use the sum of that expression from table1 into table2.

Can we get it?

Both the tables are at different levels of data.

[christian77]

In the example, I'm adding the number of rows of table 3 to the total of table 4.

Where do you want to add that value in table 2? you want to add it to every row, to one row, to the total row, to the title bar?

[udaya_kumar]

Yes, But the dimension is same in all the tables.

But in my case, Product is the dimension in table1 and Store is the dimension in table2.

[christian77]

I don't know exactly what you need since you don't place an example. if the thing is easy, or you can explain it with words, good. For more complicated things it is convenient to place an example. otherwise we play shot and error, cause I can't see the same situation you are seeing.

Here is another try with no dimension, attached.

this one may help you.