1. need to modify calculation 1 to get the right %.
need to handle NULL properly.
2. For sure you are over-complicating but still very difficult what is the right logic.
To get 2017 and 2018 individually, you only need to put "End Date" to the view.
If this helped, please mark my answer as correct to close the thread, not from inbox but from original post.
Packaged_wb_SM_10.5.twbx 38.3 KB
Thanks for your help but this is not a dual axis.
I know, but what is the intent of using dual axis?