Hi,
I have a bar chart and using pane's hidden subtotals to create white space for different panes, however, I would also like to have totals for another dimension showing in the same chart (See screenshot below), is there a way to achieve this?
Besides, is there a way showing the quarter headers at the bottom of the chart by having this view?
Thanks!
2 answers
@Teik Tee so instead of splitting the chart out by [Status], let's create separate metrics for SUM([Orders]) and split the chart out by those.
- Create three new calculated fields
- [Current Orders] = SUM(IF [Status] = 'Current' THEN [Orders] END)
- [Prior Orders] = SUM(IF [Status] = 'Prior' THEN [Orders] END)
- [Total Orders] = [Current Orders] + [Prior Orders]
- Add Measure Names to the filters shelf and select your three new fields. Then replace [Status] on both the Columns shelf and marks card (color) with Measure Names
- Remove your SUM([Orders]) from the marks card and replace the SUM([Orders]) on the Rows shelf with Measure Values
- Add Grand Totals and edit [Total Orders] color to be white (for your spacing)
See the attached workbook for reference.
I hope this helps!
Kelsie
- Create three new calculated fields
