Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I am trying to combine the values from multiple dimensions into one single axis in a bar chart. I think it's easier to explain with an example.
Let's say I have a data model with the sales of a company, and among others, I have geographical dimensions (let's say province) and product dimensions (let's say article). I can create two different bar charts, showing the total sales split among the different provinces and another one showing the sales split among articles. But is there any way I can mix the values of the two dimensions in the same graph? I also need to sort all the values by expression, regardless of whether it is a province or an article. So, for instance, what I want, in a table chart, should look like:
Dimension - Sum(Sales)
Province A - 10000
Province X - 9500
Article B - 8900
Province M - 8500
Article Z - 8000
Article D - 7000
Province B - 6500
Thank you for your help.
In this example
I have a requirement to show all the "Article" in article field with "province 1" alone from "Province" field
How do we write a pick & match expression for this