Sales Chart

[sushil353]

Hi All,

I have yearly sales data category wise. I want to make a chart and show that yearly sales data category wise.  Also in the same chart I want to show change %change in sales each year in each category. How can this be achived. Consider the sample data as below.

Year    Sales    Category

2015    50000    A

2014    60000    A

2013    30000    A

2012    25000    A

2015    70000    B

2014    80000    B

2013    30000    B

2012    95000    B

2015    50000    C

2014    70000    C

2013    30000    C

2012    35000    C

[Gysbert_Wassenaar]

See attached example

[#3]

Hi,

In dimension put year and category fields. Then in style tab click on stacked button.I did that like this.

[timanshu]

Hi,

see the above image, correct values are shown in 4th and 5th column. When using dual function, values are incorrect. How?

And when we remove just dual  or add text outside dual then data is also correct. How is this happening??

[timanshu]

Hi,

If you want it on backend, here is the attached solution

[#6]

Hi @sushil_Kumar

I Tried in this way for given data from please check this qvw file .

Please give reply after seeing the file

[fred_s]

Or something like this..

see attch

Grtz. Fred

[fred_s]

Sorry, this one is a little better..

Grtz. Fred