As we know Xcelsius does not support ‘Pivot Tables’, so to get around this we need to use a combination of Sumif’s ,Concatenation and Combo boxes. ..
If we have a table which looks something like this.
We want to have the functionality and view of the pivot table in excel as shown in the picture.
This is the Dashboard that I’ll be using for this example. Here I have used two combo boxes with labels’ being picked from the Manager’s Column and the Employee Column. The Insertion Type as ‘Label’ and the destination as the two cells marked as ‘Manager’ and ‘Employee’ on the excel sheet.(Colored Black in Excel Sheet)
Here I have used a ‘Spread Sheet table’ component. In Properties >Display Data I have used the data highlighted in the sheet. Also we need to ‘Uncheck’ the rows in the ‘Behavior’ Tab of properties so that we do not have a selected row in the ‘Spread Sheet table’.
Now we go to the table: here we need to add another column ‘KEY’ which is a concatenation of the three columns as shown. We also need to add a similar key in the display table of the sheet as shown.
Once this is done add ’SUMIF’ as shown in the cells as shown.
This entry was posted on Jun 27, 2009 at 4:25 AM and is filed under Xcelsius, Xcelsius-Formatting, Xcelsius-Pivot Table, Xcelsius-Spread Sheet Table, Xcelsius-Sumif. You can follow any responses to this entry through the RSS 2.0. You can leave a response.