How to sum the bars in bar chart and show it as a single bar

[#1]

hi,

I have a bar chart that shows sum of amount by department

it Shows sum of amount by  department (in shows 10 bars of 10 different department)

I want a bar chart that displays a single bar

[Anonymous]

Go to Style tab and select Subtype as Stacked

[#3]

PFA.

[#4]

You can try with the following expression:

sum(all revenue)

[prashantbaste]

Hi

Use of stack type bar chart will be more suitable for you.

So that you can have a single bar against multiple departments with indicator of separate color for seperate department.

Hope this will be helpful for you.

--

Regards,

Prashant P Baste

[awhitfield]

HI Gaurav,

can you use a stacked chart in stead of grouped?

Andy