topic filter on object in App Development

filter on object

ranibosch — Wed, 28 Feb 2018 12:20:02 GMT

good day,

I have a pivot table as an object on my sheet.

I sum the total quantity items sent to quarantine, total quantity purchased, and then I show the quarantined items as a % of total purchases.

this is done per lot no.

how can i filter out the 0 quarantine quantities out of my pivot table?

ErikWetterberg — Wed, 28 Feb 2018 13:30:20 GMT

Hi,

The easiest way to do this is to use a Limitation as described here:

To make this work you would probably have to make quarantine quantity your first measure.

Hope this helps

Erik Wetterberg