Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have below mentioned data. I have to create a stacked bar graph.
Dimension-Year,Customer Id
Expression-Sum(Sales)
My requirement is when nothing is selected the legend in graph should show all customer id although there is no data for last one.
Data
LOAD * INLINE [
CustomerID, Year, Sales
1,2010,2
2,2010,2
3,2010,2
1,2011,2
2,2011,2
1,2012,2
2,2012,2
3,2012,2
3,,2
2,,2
4,,2
5,,0
];
if you define "Show all values" and unclick "suppress Zero values"
the legend should Show all Customer Id
if you define "Show all values" and unclick "suppress Zero values"
the legend should Show all Customer Id