Stucked with total in pivot table

[evgeniystuchalk]

Hello! I need count total for each column of this table:

Problem is: when i'm use total, it counts all companies at all.

I need totals only for rows. My expression is:

Count({$<[Success Deals]={'>=1'}>} total distinct [ID company])

[Gysbert_Wassenaar · Accepted solution]

Add the month-year field you use a dimension in your pivot table in < > tags after the total keyword: Count({$<[Success Deals]={'>=1'}>} total <MonthYear> distinct [ID company])