3 Replies Latest reply: Apr 25, 2012 12:11 PM by Jose Tos RSS

    Problem using expression in Dimension Limits

    James Carpenter

      I have a chart with two dimensions (SalesPerson and Product Family) and the expression sum(LineSalesAmount). I want to use Dimension Limits to display only Product Family rows whose sum is less than the average of Product Family sales per SalePerson. When I enter an expression in the "Show only values that are..." window, it is ignored and the chart displays all Product Family rows.

       

      I've attached a QVW example. The yellow chart is the one where I want to display sales less than the average. Look in the Dimension Limits tab for the various expressions I've tried - all but one is commented out. FYI, this is the QV Developer training app.

       

      I appreciate everyone's feedback. I'm using this app to learn new QV 11 features.