3 Replies Latest reply: Oct 25, 2012 7:51 PM by Niels van Diermen RSS

    Filter by Negative values in a pivot table

      Hi There,

       

      I have pivot chart containing a lot of production data.

       

      One of the expressions is in the chart shows the number of Items available based on a wee bit of set analysis.

       

      There are a number of other expressions shown too that provide detailed information on the same row.

       

      The client would like to be able click a button and only see items that are of negative value. Then unclick it and see everything again.

       

      I can't think of a way to do this. Is it possible?

       

      I kind of got it working with Dimension Limits but was wondering if there was another more flexible way.

       

      eg. table

       

      Item Name | Sales Prior Period | Sales Current | Stock Available

      Item 1                    20                         18                    5

      Item 2                    14                         14                    -2

      Item 3                    11                         13                    -5

      Item 4                    9                           12                    7

       

       

      Click a button and only see Items 2 and 3.

       

      Anyway ideas?

       

      Thanks