3 Replies Latest reply: Apr 4, 2013 11:01 AM by Daniel Fleisher RSS

    Ignoring selection expression adds selections to chart

      I have a straight table chart that displays what was sold for a selected quarter and year, the last column in my table chart is an overall amount expression of all sales for this item throught time. So this column needs to ignore the selected year and quarter and sum up the total sales.

       

      =SUM({<Year=,Quarter=} NetAmount)

       

      When I do this, my table chart blows up with more rows of data of products that did not sell during the date selection. The column with the total for the current time period shows zero, but has value for the overall sum. So it looks like ignoring the selection in my expression added more selection to the chart. The goal is to keep the selection for the chart, but not for a single column.  What am I going wrong?