Count number of specific values
Hey, I have a field, in which only 3 status values are available (determined by drop-down list): Active, Cancelled, Done.
So how can i count the total number of each status values?
The way i know adds too many fields - 6, i.e. 2 fields per each status (one for extracting status, another for summary).
Is there a way to trim the number of additional fields to 3? i.e. 1 field for each status count?