Filtering error in pivot tables

Bugs
1

Hello,
I have a pivot table showing the amount of different items in various warehouses in the following link:
https://gintekik.noloco.co/depo/mevcutlar

I put a filter on values to see if anything goes below zero. The value of one item is -5 without the filters applied. When I put -1 to the max. value filter, I see the same item filtered but the new value is -15. I know the correct value is -5 and need help on this error.

Why i need this functionality: I need to filter and see which stocks are below zero in order to find out errors of warehouse managers.

Thanks in advance,
Arda.

1 Like
2

Hi @ardaergin and thanks for sending us this question.

I’ve had a look at your data, and I think the correct value is -15

The top is your pivot table, and the bottom is the raw data in a table format, with the same filters applies (-1000 ↔ -1)

image
image536Ă—938 19.4 KB

3

Hi Darragh,

The screenshot without filter:

without_filter
without_filter1203Ă—677 34 KB

The screenshot with filter:

with_filter
with_filter1205Ă—520 26.1 KB

As you can see I have 4 inputs for that stock and total SAYIM makes 5 for that stock. Breakdown to warehouses would be -5 in “BILECIK SRP” and 10 in “HÜKÜMET”. I’m trying to filter minus values but when I do it gives -15 in BILECIK SRP instead of -5.

I also put the raw data for that stock below in both screenshots.

Can you have a look again?
Thanks.

4

I’m also attaching the screenshot of the raw data with the warehouse name so you can better see:

stock_data

5

Would a max: -1 not filter out the 10 and 10 causing it to only be -5 and -10 as in my screenshot?

6

Oh i see now, it’s my bad, thanks very much.

1 Like