Stacked chart with totals
Hi Team ,
It’s simple trick to display totals of stacked column like below
at bottom (along with category axis)
How to do !
I have Business area and fiscal period wise Revenue stocked column chart.
1.Create a stacked column chart with Business Area in category axis ,Revenue in Values axis and Region Type : Fiscal Period
2.Now we need totals to display on top .Create a detail variable to get Business are wise totals .
Total =FormatNumber([Capital Cost FC] In ([Business area]);”#”)
Note : If you have big numbers ,then it is better to show them in Millions (if Value)/MT (if Quantity) .So that we can adjust totals to look like for each column.
3.Create a variable with dummy measure .This is to have measure against Detail total variable
4.Create a column chart (any chart ) with Total variable in X- axis , Dummy measure variable in Y-axis.Fiscal period in region type to have context (if any to measure)
5.Show only category axis only .Unchecked value axis, title,legend ,..
6.select palette for chart : create a custom palette with all white colors
This is to don’t show columns in chart.Format column chart category axis to show numbers in bold color .Decrease height of column chart to get the category axis and some space for columns .By doing this we should get values like below.
7.This is important part .Align this column chart on top of stacked chart so that it will appear as total of the column.
* we need to have another chart , it will heavy our report .
* we should be very concise on formatting and aligning.
* It is not possible to show very outside of each column .All totals are at same height.
Assign Total -detailed variable in category axis .Insert a blank cell , name it Totals and align it as to represent category axis total .
Totals are shown at category axis itself .We should inform to user .
Hope somebody will find it helpful. 🙂