Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for
Search instead for
Did you mean:
Creator

## How to Show grand total as bar in Bar Chart ?

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

1 Solution

Accepted Solutions
MVP

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

9 Replies
MVP

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

Master III

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

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

Creator
Author

Yes, But no luck

Partner - Specialist III

Hi Madhu,

Please  check below heck box: as Suggested by sunny

Thanks,

Arvind Patil

MVP

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

Creator
Author

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

MVP

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

Creator
Author

Thanks Sunny ,

Working perfect

Contributor

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!

Community Browser