Hey!
I have the following chart
I would like to show on this chart the total number per category, not 2 numbers per each colour
(e.g. first touch =4: blue area: $ 2, grey area: $ 7
I would like to show on the chart near 4th group $ 17)
Could you help me how can I do that?
Thank you in advance
Karolina,
This is a pretty straight forward issue that you tend to face quite a bit, and is easily solved with dual-axis. Here's an example using the superstore dataset.
For example, let's say you start with the following: Sales by category, and the sub-categories are shown as various colors on the bars:
Now, we just want to show the total sales for each Category, and not for each sub-category. So we drag Sales to the Columns shelf for a second time, and right click it, and select dual axis. The result is:
Notice that on the Marks shelf, you now have multiple tabs, SUM(SALES), and SUM(SALES) (2). Click on the SUM(SALES) tab, and remove the Sub-Category from Color:
And drag the Sales measure to the Label tile on the Marks shelf, so you have the following:
Now you can synchronize the axes, and don't show the header of the top axis (or the bottom axis), and you should now have something that looks like this:
Hope that helps. Please let us know if that solved your challenge.
Kaz.
