I have a PivotTable with activity name (horizontal) and resource (vertical) as dimensions.
I have case count as KPI, this works as expected. Activity count however returns ‘1’ in each cell which is non-zero. Using
COUNT_TABLE() works correctly however.
Any logical reason why this happens?