Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a chart in which I have two dimensions (such a in the below Excel example): Group as the first dimension and Item as the second dimension. The next column(s) are defined by my expression.
I would like to count the number of items for every group, and put it between brackets next to the Group description: A (1), B (2), C(2) and D (4).
However, the following does not work:
= Group & ' (' & count(Item) & ')'
Any ideas?
Thanks and regards,
Fréderic
Hi Frederic,
You should make this as dimension:
=Group & ' (' & aggr(count(Item),Group) & ')'
You have to aggregate count(Item) via first dimension - in your case Group.
Regards,
Miha
Hi Frederic,
You should make this as dimension:
=Group & ' (' & aggr(count(Item),Group) & ')'
You have to aggregate count(Item) via first dimension - in your case Group.
Regards,
Miha
Works like a charm
Thanks Miha!