Comments
-
I'm not sure if I followed your logic exactly, but I was able to solve this issue with an ETL dataflow. I filtered my data into 2017 and 2018, then split the 2017 data into two copies, where one copy is used for the 2017 bar of the waterfall, and the second copy is combined with the 2018 data to calculate the variances of…