how to add specific values to pivot table on excel?

[hellokitty0234]

hello,

[#2]

@hellokitty0234 Why not add a column that identifies the negative values and add that column to the Filter area?

[#3]

reply

[#4]

@hellokitty0234 

In general creating PivotTable you may add data to data model, generate DAX measure

Count negative:=CALCULATE( COUNTROWS( Table1 ), Table1[value] < 0 )

and use it in PivotTable: