
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Graph Issue
Hi,
Please see attached. There are three issues that I am trying to solve:
1) I want to stop the Curr Yr Actuals YTD line extending beyond June 2017. It is currently extending beyond the current year.
2) I want to include a cumulative to date Actuals line starting in Jan 2017 (the value in Jan 2017 being Full Year Actuals 2016 + Actuals for Jan 2017 = 1235) and then extend out to June 2017 ( the value being 2610).
3) Need a vertical reference line separating the years.
Appreciate your assistance.
Thanks


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Hope this helps.
Cheers

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Federico,
Thanks for the info. I have used parts of your solution.
I am still struggling with the Curr Yr 2017 YTD Actual line to end in 2017 Dec. It is extending out in 2018.
Any ideas?
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What was the expression you used for CY 2017 YTD??

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That was used to calculate the year to date figures for the Current Financial Year i.e. 2017. This period runs from 1 Jan 2017 to 31 Dec 2017.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Shamit,
Try with this
Hope helps.
