Send to Excel

[Anonymous]

When I send my data from a table to Excel I always have a leading empty row inbetween the header and the first row. How can I remove this empty row?

[Clever_Anjos]

Would you mind posting a screenshot?

[vcanale]

Hi,
what if you export in .csv?
same issue??

[Anonymous]

It's the Totals row in the presentation tab. When I select totals on last row and when I send to excel it displays on the top

[Anonymous]

See attached for example. If I send the chart to excel the totals row displays on the top row and not the bottom row.

[Anonymous · Accepted solution]

I figured it out. The problem was in the Expressions tab I needed to select Total Mode to No totals!

[vcanale]

If the row is empty (so you do not have any Total), just select "No Totals" in the Expressions tab

[Anonymous]

Check your chart properties. Expressions-->Total Mode--->Select No Totals (of course if you do not need totals). Then you can select Column totals via the Presentation tab.