Displaying Grand Totals in Table

[Former Member]

Hi Experts,

I have a web-service which i use to bring data from rich client block in xcelsius with 3 rows, i map rows to excel with 5 rows, because sometimes we can have more rows in block. And I map the footer row to 6th row in excel.

While showing this data in spreadsheet i select 'ignore blank rows in the end'.

The issue is how to show Grand total without having blank rows in middle?

This is how it looks in xcelsius right now.

State, Revenue

NY, 500

NJ, 200

PA, 100

--

--

Grand Total, 800

This is how we want to see data

State,Revenue

NY, 500

NJ, 200

PA, 100

Grand Total, 800

It works fine when i don't want to show 'Grand Total', but users need to see 'Grand Total' as well.

Any Suggestions.

Thanks

[former_member182541]

As a workaround you can do two things,

1. Bring the grand total to the top of the row, write the sum formula on top of the rows and map with that cell.

2. Take the row items in one component and add one more component to pick only the grand total, but make sure the alignment is done properly.