Filter base data set for pivot

[Cunner]

Hi everyone,

I have a very large dataset with e.g. names, year and income (which can be positive or negative).
In my pivot I want to have the rows showing the names and the total income.

I now would like to add a filter to the pivot table, such that the tables uses as input data only specific cells, in my example only rows when the income is greater than 0.
In theory I know that I could just add "income" in the filter section of the pivot and select all positive values. Due to the large data set and the fact that incomes are all different, this is tedious and takes a lot of time.

Since Excel can filter based on a manual selection of values I am pretty sure that Excel could filter based on a given criteriy (just like normal filters in a sheet).

See the attached file for a very simplified example.

Thanks a lot for your help.

PS: Of course I could add a column in the data base where I use an if-formula to give me an indicator (e.g. >=0, <0) and use that as a filter, but of course this is quite unflexible.

[stasinek]

I do not know if I understood you well - see attachment