3 Replies Latest reply: May 29, 2012 5:41 AM by Jean-Paul Camelbeek RSS

    Set Analysis



      I need a little help with set analysis.


      I have a stacked Bar Graph with 2 expressions:


      1) Total Hours Logged for Transactional Work - Colour blue

      2) Total Hours Logged for Non-transactional Work - Colour Red


      All my data has a field called TransactionType that indicates if a transaction is 'Transaction' or 'NonTransaction'


      I am using set analysis in the bar graph to select the relevant transactions for each expression.








      this all works fine, however if I add a listbox to the sheet with transaction type and then select 'NonTransaction' the numbers reduce but I still see both expressions and hence both bars in the stack. I would have though the 'Transaction' bar would disappear from the graph as it has been eliminated by the current selection???