This content has been marked as final. Show 2 replies
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) & ')'
Thanks and regards,