Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
R_ym0nd79
Contributor
Contributor

Total vs branch on a single bar chart

Hi, 

I have a bar chart where (with out selections) show the total number of sales by age band from all branches. What i would like to show is the bar chart with the totals and next to it a specific branch total. This way i can display the total by age against the specific branch by age? Any ideas on how i can do this. This is one graph and I have about 6 graphs to do this too. I am pretty sure if i get one right I can easily figure out how to change the rest. 

1 Reply
Alaaaq
Contributor
Contributor

using set analysis you need to set two measures

1- sum(total sales)

2-Sum({$<Branch={'required branch'}>} Sales)

and then change the presentation to stacked bar chart if required.