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

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:

Forum Discussion

hellokitty0234

Copper Contributor

Jan 24, 2023

how to add specific values to pivot table on excel?

hello,

excel

3 Replies

Riny_van_Eekelen
Platinum Contributor
Jan 25, 2023
hellokitty0234 Why not add a column that identifies the negative values and add that column to the Filter area?
- hellokitty0234
  Copper Contributor
  Jan 25, 2023
  reply
  - SergeiBaklan
    Diamond Contributor
    Jan 25, 2023
    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: