Send to excel brings the totals row to the top of straight table

[srchilukoori]

Hi,

I have a straight table, where I'm showing the totals of the expressions on the last row on the QV application. When I send this chart to excel (send to excel option) the totals rows is moved to the top of the chart in the excel file.

I'm using QV 11.2 SR 11, Please let me know if there is a fix for this.

Thanks much.

[srchilukoori]

update:

We upgraded from 11 SR2 to 11.2 SR 11, the totals row format was working fine in 11 SR2.

[Clever_Anjos · Accepted solution]

It´s a known issue,

At your expression mark as "No Totals"

Using the tab Dimension Limits, please check "Show Total"

[srchilukoori]

Thank you Clever, it fixed the issue.

[srchilukoori]

Clever, This seems to work with one expression, any fix for tables with multiple expressions?

[varunreddy]

Hi,

You need to select each expression and check 'No Totals' option

Regards,

Varun

[Clever_Anjos]

Using your sample and 3 expressions

[#8]

I am experiencing the same issue while exporting from accesspoint.

I have a chart / straight table.

I understand when you say 'No totals' on the expression but the columns that i want the totals for are not a dimension on my chart. They are only as expression and hence do not appear in the list on Dimension Limits tab .

How do I get around this to show totals on the bottom .

Thanks

[janterje]

Hi.

This seems to be fixed in SR13.

JT