Filter by Negative values in a pivot table

Thu, 18 Oct 2012 00:08:16 GMT

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

Re: Filter by Negative values in a pivot table

Thu, 18 Oct 2012 02:29:10 GMT

Hi,

Please see attached.

Regards,

Janzen

Thu, 18 Oct 2012 05:11:24 GMT

Hi,

See the qvw attached.

Two buttons are used, showing/hiding by using var values in layout/conditional tab.

Please mark answered if this helps !!!

Regards

Thu, 25 Oct 2012 23:51:43 GMT

Brilliant. Thanks very much for you help.

Sorry for my delay in responding.