

Creator II
2014-10-06
02:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
CY vs PY Comparison in Line chart
I want to show Details Of CY and PY in single report..
based on Year and Month.
For example..if i selected Current Year and May month...same chart need to display Previous Year and Previous year may month..
22,291 Views
1 Reply


Specialist III
2014-10-06
02:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Create a variable vPrevYear = Max(Year) - 1
Use these two expressions
Sum({<Year={$(=Max(Year))}, Month={$(=Max(Month))}>} [Your Field])
Sum({<Year={$(vPrevYear)}, Month={$(=Max(Month))}>} [Your Field])
16,244 Views
