How to display Bars?

[#1]

Hi ,

I have 4 years of sales and i created a bar chart for Present year sales,previous years sales month wise but i want to represent

present year sales according to month wise remaining all years sales i want to represent as a single bar.how to achieve it please guide me .

Thanks.

[#2]

Thanks Nagaiank,

in the above chart 2011,2012,2013 years data also it has to show in a single bar that is my scenario. i will work around it. thanks once again.

[Anonymous]

Hi John,

PFA. I have modified Nagaian qvw.

Ignore the QVW Name. I have created single bar only for all other years.

BR,

Chinna

[its_anandrjs]

Hi John,

You can try also for dynamically load the current year data as month wise and rest of the data as Year wise

1. First way

Dim:- =If(Year =Year(Today()),MonthName(Datefield),Year) //Calculated Dimension

Expre:- sum(sales)

2. Second Way

Dim:- =If(Year =Year(Today()),MonthName(Datefield),'All Year') //Calculated Dimension

Expre:- sum(sales)

Regards

Anand

[#5]

hi Chinna katiki

Thanks for your help.but i am using PE so i can't able to see your application.