I have a webi report which displays data as below
2010 US NJ 8
2010 US NY 5
2010 US CT 6
I pull this in Xcelsius as webi report using Live office .I need state filter on this with option 'All 'such that it gives sum of all states (i.e US).
Can any one explain in detail
chulbulPandey (BOB member since 2012-08-26)
So say you map the output of your liveoffice data to cells B5:B50. Type the word ALL into cell B4. Set your filter component range to be cells B4:B50. Now you have a filter with your states, plus the top one will say ALL. Map the user’s selection to a different cell and calculate what to display according to what they select.
debbie
Debbie 
(BOB member since 2005-03-01)
In addition to Deb’s answer, in column D4, you could create a sum for all of the column so you get the total for ALL.
kapittock 
(BOB member since 2006-01-24)