I have a multi Valued field in table. These values are repeated in many
rows. I want to count each value in all rows. Could you please provide me
query to do that.
e'g in the following table I want to know the count of Baseline = 2,
PMI_KCOO = 2, PMCS = 3, shopp2005 = 1, KC00ACT_AllMilestones = 3
Baseline(XX), PMI_KC00
Baseline(XX), PMCS, PMI_KC00
Allocation(XX), PMCS
KC00(XXX), PMCS
PMCS, shopp2005, K00ACT_ALLMILESTONES
PMCS, KC00ACT_AllMilestones
PMCS, KC00ACT_AllMilestones