Workaround for "All" selection


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



  1. Hi,

    Which Xcelsius version u r using to create this? I tried same thing but If I go directly from “All” to “Bill”, It selects first item “Bob” in my Xcelsius.
    It works fine here with your swf.
    I am using 5.1.1 Do I need any Fp to make it working like yours

Leave A Reply