This content has been marked as final.
Show 4 replies
-
2. Re: Month-To-Date, Prior Year-To-Date, & Month over Month Change Calculations
Marc Levy Nov 15, 2017 4:59 PM (in response to Norbert Maijoor)Apologies. Please see the attached workbook as an extract.
-
3. Re: Month-To-Date, Prior Year-To-Date, & Month over Month Change Calculations
Shinichiro MurakamiNov 15, 2017 6:27 PM (in response to Marc Levy)
HI Marc
I am not sure how you want to handle M to Date on line chart.
Because the latest month does not have full month, it is not showing trend correctly.
How do you want to handle this?
Line chart is always showing Full month and all others are start(month/year) to date?
I cannot find easy answer on this with considering the combination of whole logic and function limitations.
Thanks,
Shin
-
4. Re: Month-To-Date, Prior Year-To-Date, & Month over Month Change Calculations
Shinichiro MurakamiNov 15, 2017 6:33 PM (in response to Shinichiro Murakami)
2 of 2 people found this helpfulAnyways, up to now.
Share Date filter across whole sheet with linking "Date" field on both data source.
Change the date filter to context to capture the latest date with LOD correctly.
==> This does not allow to draw the correct Line chart for the latest month.
Thanks,
Shin