How Can I Create A Stacked Bar Chart From A Summary Field and Product Field
I am trying to create a stacked bar chart from a summary field and a product field to show up in a dashboard layout.
I think what I am trying to accomplish is simple, but that I just don't know the correct syntax to be able to filter the chart.
Here is what I have:
Product Field - in here there are two types of product A and B
Summary Field - is a summary of the total cost of product Field
Date Field - showing dates
Month Sort Field - showing months
I can create a normal bar chart which shows the combined total of A + B in per month. This works perfectly.
However, I would like to show it on a stacked bar chart where I can see the individual total for A + B.
Does anyone know how to do this? I would appreciate any help.
Is it done with a calculation from the chart screen for the X or Y axis? Is it something to do with the way the data is sorted?