Get sum for each possible value of dimension in text obnject

[karin_nevo]

Hi,

I want to display the total of each dimension in text object.

For example, if I have the following chart data

Dimension         Count(ID)

A                             10

B                             12

C                             20

I want to display it in text object as follows:

A: 10, B: 12, C: 20

Of course, the dimension values is not constant and can also change based on user selections.

I tried to use concat and AGGR function with no success.

thanks,

Karin

[sunny_talwar · Accepted solution]

Something like this

Concat(Aggr(Dimension  & ': ' & Count(ID), Dimension), ', ')

[karin_nevo]

it works. thank for your help!