This content has been marked as final. Show 5 replies
I want to build PIVOT table using following data:
When I choose Month and Year on the filter pane, I want the PIVOT to show me [Revenue] for:
Let's say I chose MARCH and 2017. There are only 7 days with the data, the [Revenue] measure would be calculated for 1-7 days of March in 2017 vs 2016, and the difference.
So far, I was only able to create two different [Revenue] measures for CY and PY, but this does not work for me.