5 Replies Latest reply: Nov 6, 2012 3:52 AM by imustdash RSS

    Set Analysis - stacked bar chart question



      I have a stacked bar chart with multiple expressions which I need to show the contribution of several groups of data to a total. I am using the following expression:



      sum({$<CollsFlag={1},RPC={1},TranfAMFlag={1},Group={"Closure"},RemoveFlag={0}>}Closure) / sum({$<CollsFlag={1},RPC={1},TranfAMFlag={1},RemoveFlag={0}>}RPC



      For each group of data I am changing the={"Closure"} part to match another of the groups. This worked fine until today when I corrected the join between the inline table defining the different groups as it was brining through duplicates. Now it has stopped showing any group other than the Closure. I have tried cutting and pasting the expression that works over the ones tat do not but this doesn't help.


      Thanks in advance for your help!