I need to create a Scatter chart with X axis being sales adn y axis profit. The dots in the chart should represent articles.
And articles of one category should be of one colour. ie. if categoy A has 10 articles then all the 10 articles should be of one colour and the articles of other categories should have other coloiurs.
I have used sum(sales ) and sum(profit) as the expressions. I have selected around 4 dimensions, because I want to represent each record of the data source so I selected a combination of columns which is the unique key foir the data source.
Now, I want these dots to be grouped as per the group they belong to. I was able to do that but now I have problems choosing the legend. I want a bmc_desc(attaching a qvw) as the legend and dots should be grouped by this bmc_desc. Can you please suggest how to configure the legend?
Other than changing the window title, it does not help me much. When I select bmc_desc, I see that for each of the bmc' there is one dot. But my requirement is that underr each bmc there are many articles and I want to see all those articles for that bmc.
Like in this case, under coffee there are many articles(read different types) . So , I want all those to be represented there, why are they getting aggregated, any idea?