Bar Chart expression

[#1]

Hi Team,

I want to show the Total Value for Each month at the top of the each bar. Eg: 1000 - at 0314 bar , 2000  - 0614 bar etc..

Can this possible?

[#2]

Hi Taras,

You gave me a good option, Now atleast i can able to show total value as shown below.

But it is showing 3 values as it contains 3 categories, How to eliminate this? I have attached sample report. Thank you.

[JonnyPoole · Accepted solution]

ok. i got interested

i put this expression in the subtitle to space out the totals horizontally across the top

= concat( aggr(sum(total <ReportMonth> Value),ReportMonth) ,  Repeat(' ',160/count( DISTINCT ReportMonth)) ,ReportMonth)

hold down the CTRL/SHIFT key and click the chart ,you will see red lines and you can move the legend, title around as you see fit. i found the spacing works better if the legend is NOT on the side but play with it, maybe you can get it to work by pushing the title a little left off center. 

in the expression above play with the '160' number if you resize the chart to space the totals right.

good luck !

[sunilkumarqv]

@@Plz check attached

[#5]

Hi Jhansi,

Please check attached file.

Hope it will help you

[#6]

That's a fantastic idea. Thanks a lot for your help...

[#7]

Thanks to all for your cooperation. I got a solution.