Total of expression in straight table vs. pivot table

[p_noindl]

I have a problem with totals in straight/pivot tables - anyone has an idea how to solve it. Example attached.

[CELAMBARASAN · Accepted solution]

For Pivot table use the expression as

=Count({<Customer={"=count(Visits) >= Sum (Target)"}>} DISTINCT Customer)

[p_noindl]

Hi,

many thanks!