BusinessObjects Board

Displaying Grand Total in Spreadsheet Component

other Xcelsius - Crystal Dashboard Design
#1

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 Totals’, but users need to see ‘Grand Total’ as well.

Any Suggestions.

Thanks in advance

AZ_Dev (BOB member since 2016-05-29)

#2

Figured this out using combo-box and excel flags(y,n). Any other way if we have, lets discuss here.

Thanks

AZ_Dev (BOB member since 2016-05-29)

#3

I always put my totals at the top instead of the bottom in the underlying spreadsheet, for this very reason. Depending on the display component used, you can still display on-screen in the right place.

Debbie

Debbie :uk: (BOB member since 2005-03-01)