When you have selectors in Xcelsius, there is no good way to create an “all” selection. Here is a technique that I use which requires 1 extra column containing an IF() statement and a second transparent selector. Overall the solution is extremely lightweight without a lot of extra work while remaining completely data driven. I have another technique with 2 dimensions, where you can dynamically roll up the data using Filtered Summary, so I will try to post that one next week.

Download Source Files

All rights reserved Goodman Group LLC