Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
I this case you cannot use dimension. you need to add expression for every bar you want to create in the chart.
Can you explain to me what you want to achieve exactly, please ?
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.
Maybe with some calculated dimension using valuelist or valueloop
Hi Macro Wedel
Can"t we achieve it through Set analysis.
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.
Hi Nagaiank
If you don"t mind can you please provide an example on it how can we achieve the scenario.
An example is attached with dummy data that produces the following output. Hope this helps.
It is cool..Nice one Nagaian