Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a simple table showing a count of work activities by type (down) and month (across). The expression is simply: count(distinct activity). I am using distinct because for each day there are two records, morning activity and afternoon activity, but I am not interested in this split to be shown in this table.
The issue is that if I add totals they are wrong. What i am looking for is just the sum of the row values (counts), but the totals are different.
Any clue ? how can I get the right totals ? I have noticed that in object Properties totalization rules are grayed when the expression is a count, I don't understand why.
Thanks for helping.
Nik
I am using Ver. 9
Hi,
Since you're using a pivot table the different types of expression totals are greyed out.
The distinct count totals might be different since a certain activity might show up for both Jan and Feb but since we only calculate distinct values the total will just show 1 instance for the activity.
You'll want to use aggr() in your expression to aggregate the counts over each dimension combination and then sum them up. Something along the lines of:
sum(aggr(count(distinct activity), type, month))
Good Answer