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.

[alkesh_sharma]

I this case you cannot use dimension. you need to add expression for every bar you want to create in the chart.

[ecolomer]

Can you explain to me what you want to achieve exactly, please ?

[#4]

Thanks Enrique Colomer

I want to represent present year sales according to month wise[means for every month there should a bar] remaining all Previous years sales i want to represent as a single bar[means for all entire previous years should be one bar].

Please let me know for any additional information needed on the same.

[MarcoWedel]

Maybe with some calculated dimension using valuelist or valueloop

[#6]

Hi Macro Wedel

Can"t we achieve it through Set analysis.

[nagaiank · Accepted solution]

Assuming that month field is defined by the date field Period (the month-start date of the data month), you may use the following calculated dimension.

If(Year(Period) <> '2014',Year(Period),MonthName(Period))

Also set the sort order to Period Ascending.

If your current year is not 2014, you may need to modify the expression depending on your data.

[#8]

Hi Nagaiank

If you don"t mind can you please provide an example on it how can we achieve the scenario.

[nagaiank]

An example is attached with dummy data that produces the following output. Hope this helps.

[Anonymous]

It is cool..Nice one Nagaian