Xcelsius spreadsheet table

[Former Member]

Hi, I have a question regarding xcelsius spreadsheet table.

I want to use a combo box where user can select different months (Jan- Dec)

When selecting Jan from the combo box,

it should display 2 spreadsheet tables with different data

when user click on the another month, data in the 2 spreadsheet tables will be changed too.

Something like this (http://www.analytics-tools.com/2009/08/xcelsius-spreadsheet-table.html)

However, I am unsure of how to create this. Can you kindly guide me ?

[former_member190855 · Accepted solution]

You should a bind the month names column to the Label properties

Insertion Type = Filtered rows

SourceData = main data from which you want to filter

Destination  = A smaller data range usually with same number of columns as the source = also the range you want to display in the spreadsheet.

You should also go through the basic of selectors just for future reference.

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/3093dcdd-4d2e-2e10-2292-db4687e8aff5&override...

Thanks

Runali