Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.