How to Show grand total as bar in Bar Chart ?

[madhubabum]

Hi All,

I am having the scenario like , Need to include Grand total as bar in the same bar chart on top.

Data :

      Product, Sales

    Product A, 100

    Product B, 200

    Product C, 300

    Product D, 400

Note : I want to Display 'Grand Total as 1000' in my Bar chart, on top of the chart

Any suggestions ?

Regards,

Madhu

[sunny_talwar]

Did you tried to check 'Total' on the Dimension limits tab?

[prma7799]

Go to Presentation >> Text in chart >> add your expression .

On your need you can place this at anywhere in your chart

[madhubabum]

Yes, But no luck

[arvind_patil]

Hi Madhu,

Please  check below heck box: as Suggested by sunny‌

Thanks,

Arvind Patil

[sunny_talwar]

Would you be able to share a sample where you are trying this?

[madhubabum]

Hi Arvind,

Thanks for Help..

Here i am getting the Grand total in the bellow chart, But i want to show Grand total on top of the bar

[sunny_talwar · Accepted solution]

Try this

Create a new field in the script

Load * Inline [

Dim

1

2

];

and then try this

Dimension

Pick(Dim, Product, 'Total')

Expression

Sum(Sales)

Sort tab, use this expression

Only({1} Dim) and then sort this in descending order

also make sure that sort by text is also checked

uncheck everything else

[madhubabum]

Thanks Sunny ,

Working perfect

[SteveInVT]

Thank you so much, @sunny_talwar .  This post helped me solve 3 different issues that I was having!  I had no idea the Pick function could be used this way.  Thanks again!