I am trying to build a chart that compares YoY growth across cities. X axis would be the city, primary Y axis would be revenue, secondary Y axis would be % change, and the series(grouped bar) would be YTD revenue, and Prior Year YTD revenue.
I can't seem to do this in the YoY charts because I need to show the cities on the X axis. It seems I need the proper BeastMode calculations to set this up. Can someone point me to a way to calculate current year YTD revenue, PY YTD revenue, and the % change between those two? Full year does not work because is not an apples to apples comparison as 2018 has just started.
The attached screenshot is a general idea of how I'm trying to organize the data.
Thank you!