Export to Excel: Total of Straight Table always on Top

[Anonymous]

When I define a straight table I can define whether the totals are on first or on last row

    

Exporting to Excel  of a straight table always brings total on top

when I set "Total "under Dimension Limits it shows correct (first or last row)

(but I cannot define sum of rows for some expressions which i need)

Display                                Excel

is there a chance to get the desired result without using total under Dimension limit?

We are using Qlivkew 11.20 SR12

Any feedback is highly appreciated

[canoebi99]

Hi Rudolf,

I found this was introduced in SR12 and it is a known issue.

At your expression mark as "No Totals"

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

or upgtade to v12 as it seems to be fixed again in the first release of v12.