2 Replies Latest reply: Sep 30, 2010 10:09 AM by Fréderic Cordier RSS

    Count number of subdimension items

      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?

      error loading image

      Thanks and regards,

      Fréderic