value in the bar and sum on the bar

[#1]

Hi all

I have this chart:

Is it possibile having the sum above every bar?

thanks in advance

Luca

[jerem1234]

I do not think so since you have plot inside segments checked (can't have both), but you can put on axis by adding another expression and calculating the total that way, just check Text on Axis and Uncheck Bar chart:

Hope this helps!

[Aurelien_Martinez]

Hi,

You can add an other expression like :

Column(1)+Colunm(2)+Column(3)+Colunm(4)

and on the Display Options panel

uncheck Bar and check Values on Data Points

Best,

Aurélien

[Gysbert_Wassenaar · Accepted solution]

Not in one chart, but you can get the totals below the bars. See attached example.

[ashwanin]

If you want to put the values on the datapoint then

Right Click on graph--> Properties-->Expression-->Check field  Values on data point. It will display data above the graphs.

[#6]

thanks.

how I write the expression? could you post an axample?

luca

[jerem1234]

The expression would be the total of each of the 4 segments for your bar. Just add them together or sum them up, depends on your expression(s) for getting those numbers. How are you calculating now?

Hope this helps!

[#8]

in my chart, X-dimension is

=Pick( Match (left( Text(QuarterName([Ingresso Contract Analysis])),1), 'g','a','l','o'), '1Q ','2Q ','3Q ','4Q ') & right(Text (QuarterName([Ingresso Contract Analysis])),2)

how can I use this in a expression like "count(total <Month> Sales)"  ?

luca

[Gysbert_Wassenaar]

Well, you can't. The sane way out of this is to create the quarter field in the script and then use it as dimension in your chart instead of that calculated dimension you have now. You can simply reuse the expression of your calculated dimension in the script to create that quarter field in the same table you load the field [Ingresso Contract Analysis].

[#10]

ok, thank you very much..

luca