Again, sum of columns on Pivot table

[maurorinaldo]

I read some old answers but I cannot reach the solution.  Please help me..

I have a pivot table with sum ov value for name and years

The "S" colums as "if V is more then 5.000  then 1 else 0 "

I would like to have the sum/count of each "S=1" on Total colum, not always 1   (ex. last row should be 2 , since 2 columns have 1)

Thk

Mauro

[Gysbert_Wassenaar]

Can you post an example document with some data?

[maurorinaldo]

Here an example

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[maurorinaldo]

Thank you very much!