Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
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])
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])