Show values in YTD basis?

[dmohanty]

Hi All,

Currently I am showing the Total Revenue by Quarter in a Bar Graph, means for each Quarter, I have some Revenues.

Now my requirement is to show the Revenue in a YTD basis in a Bar Graphy and compare the both charts.

How to calculate in YTD basis? Please guide.

Let say my table has this values:

Quarter	Revenue (Mn $)
Q1	150
Q2	100
Q3	120
Q4	180

[#2]

Hi DMohanty,

PFA for your reference,

Hope it will help...........

[jagan · Accepted solution]

Hi,

PFA file for solution.

Regards,

Jagan.

[dmohanty]

Thanks a lot Jagan and Saranya,

It really helped and I learnt a new thing as well.

Many thanks again.