Bar chart

[mario-sarkis]

hey all ,

i  am creating a bar chart with a dimenssion of Month ,

i need to calculate a sum of amount on each month for 2 years obviously will show two bar next to each other in a single month..

Is it possibel to add one last bar calculating YTD ?

Thank you hope you can help.

[gautik92]

it is posible can yu attach sample data?

[#3]

Hi,

You can create a separate Bar chart for YTD and you can remove all the dimensions and layout, borders etc and You can place on that chart.

Thanks

[tresesco · Accepted solution]

In the Dimension Limit tab, enable 'Show Total'

[#5]

Hi,

Follow tresesco guideline.

[nagarjuna_kotha]

PFA...

[mario-sarkis]

Hi Tresesco but if i need to show instead of the total of last year once checking "SHOW TOTAL"

i need to show the sum of Amoutn in the last year in the same period of this year

Example:

in the total Bar for this year i am showing the sum of amounts till today ( sep-2015)  my request is to show the bar of 2014 calculating the sum of amount till Sep-2014

when checking the "Show Total" it will show me the total sum off all 2014 year

hope you can help in this ?

Thank you in advance

[nagarjuna_kotha]

Please check above attached it might help your requirement.

[mario-sarkis]

Hi nagarjuna.kothamandi but if i need to show instead of the total of last year once checking "SHOW TOTAL" 

i need to show the sum of Amoutn in the last year in the same period of this year

Example:

in the total Bar for this year i am showing the sum of amounts till today ( sep-2015)  my request is to show the bar of 2014 calculating the sum of amount till Sep-2014

when checking the "Show Total" it will show me the total sum off all 2014 year

hope you can help in this ?

Thank you in advance

but if i need to show instead of the total of last year once checking "SHOW TOTAL" 

i need to show the sum of Amoutn in the last year in the same period of this year

Example:

in the total Bar for this year i am showing the sum of amounts till today ( sep-2015)  my request is to show the bar of 2014 calculating the sum of amount till Sep-2014

when checking the "Show Total" it will show me the total sum off all 2014 year

hope you can help in this ?

Thank you in advance

[mario-sarkis]

Hi @sunindia can you help in this ?