Straight table vs table box

[reshmakala]

Hi all,

I have to show few transactions as a straight table with totals.

my data is as below:

Institute     Year     Amt1     Amt2     Amt3     Amt4

ABCD       2015     0.00     85.43     1000.23     32423.32

ABCD       2015     0.00     0.00       1098.43        23.32

I do not want to sum these up but I need totals at the top. When I show this data in straight table by putting these amount field names as expressions nothing comes up. When I use a table box I can see detail transactions but I am not able to show a total there? Any help why this problem with Straight table? Please find my test application attached.

Thanks in advance.

[kuczynska]

Hi Reshma,

Probably you did check that already, but I think straight table always puts the Totals into the last row by default (or maybe pivot table does? not sure). You can change this option by going to Presentation tab:

Second thing you might want to check is to make sure that the Total option has been enabled in the first place - go to Expressions tab and check the below:

If the above seem to be ok in your case - well, we can have a look again at your expressions.

Michalina

[reshmakala]

Thank you! This helps me!