11 Replies Latest reply: Jun 27, 2014 4:05 AM by Marco Wedel

I have a bar chart showing numbers let say per sales

30

25

20

Is it possible to add numbers of Sales men in the bracket.

So the numbers will be looking like this

20(3)

25(4)

30(5)

• ###### Re: Chart with additional data

Hi Robert,

In general yes let me imagine your table structure like this:

Sales Man | Sales | Number

Jhon | 30 | 3

Mary | 25 | 4

Xavier| 20 | 5

You can try Sales Man as Dimension and this expression: =Sum(Sales) & '(' & Number & ')'

Best Regards.

• ###### Re: Chart with additional data

Thanks but this does not work.

As it will take the second calculation and merge with first one and the result is a blank chart.

I think I need a text wrapper for the sum of the second calcaulation but I can not find an appropiate fuction.

• ###### Re: Chart with additional data

You need an aggregation function around both parts:

=Sum(Sales) & '(' & Sum(Number) & ')'

• ###### Re: Chart with additional data

Still does not work.

Coudl you provide an exaple?

• ###### Re: Chart with additional data

Add a new expression and uncheck bar and only show data points

• ###### Re: Chart with additional data

In this situatio whe  let say the Sales will let say 50,000 ad only 1 sales men the data will be not visible.

• ###### Re: Chart with additional data

I'm an idiot and Thomas is right. I see what you mean about the wild difference in values though. I suggest you use Dual() to give the Salesmen sum the same value as the Sales sum, but present using the Salesmen sum:

Bars expression = Sum(Sales)

Bars2 (only data points) expression = Dual('(' & Sum(Number) & ')',Sum(Sales))

See if that works...

Jason

• ###### Re: Chart with additional data

Hi,

This thing can be achieved through the dual function

dual(Sum(Sales) & '(' & Sum(Number) & ')')

,

Sum(Sales))

• ###### Re: Chart with additional data

Hi Robert,

the already proposed dual function could work like:

```=Dual(Sum(Number)&' ('&Count(DISTINCT [Sales Man])&')', Sum(Number))
```

hope this helps also

regards

Marco

• ###### Re: Chart with additional data

Thnak you Marco

• ###### Re: Chart with additional data

You're welcome

Regards

Marco