1. i'd like to have a stacked bar chart that displays always, regardless of filter selections, chikfila sales by branch, so Johnstown 2.3, Frederick 6.7, and Windhym 5.1, and then a sum of all the others, so Others 8.1. However, if a user selects BK from the filter drop-down, i'd like the chikfila sales to stay the same, Johnstown 2.3, Frederick 6.7, and Windhym 5.1, and the Others stacked bar to switch to the sum of BK Johnstown and Frederick of 3.1 only.
so, based on what i'm describing, would my Chikfila expression be
sum({1}{$<Name={'Chikfila'}>} Sales)?
However, this doesn't break chikfila out by the branches... how do I get it to break out the individual branches as well? would I aggr it by branch? is this possible?
My others sum would be sum of sales not equal to Chikfila...what is that syntax?? sum({$<Name NOT EQUAL TO {'Chikfila'}>} Sales)?
2. how can I ensure that regardless of other page filters/selections that these charts always display what is unique to this individual tab?
no..the bar charts. I'd like every bar chart to have the branches of century 21 new millennium sliced out on the bottom blue, and then for the red bar, I'd just like a lump sum of the others...I don't care about the companies and/or the branches. I'm trying to show how much c21nm represents out of all listings...but I want to show how much each branch of c21nm represents out of all the listings.
Purples are everything else and Blue, yellow, green and red bars are the branchs for C21.... I have attached the sample app here: Re: General charting questions
Expression is this
=Pick(Dim,
Sum({1<ListOfficeName={'Century 21 New Millennium'}, ListDateFlag={1}>} OriginalListPrice),
Sum({1<ListOfficeName-={'Century 21 New Millennium'}, ListDateFlag={1}>} OriginalListPrice))
