Forum Discussion
how to add specific values to pivot table on excel?
hello,
hellokitty0234 Why not add a column that identifies the negative values and add that column to the Filter area?
reply
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:
