I have a particular question based on my dataset requirement.
I am using Pivot Table and I have Summary field in Dimension and Month field in Column and I have 3 measures - Actual, Budget and Forecast.
The output I want is from "Jan to Aug" Month the measure shown in the pivot table should be actual and Budget but from Sep month which is the current month and onward I want to see all 3 measures Actual, Budget and Forecast.
I am using show if column condition in the Forecast measure, but its not working properly. Either its showing forecast for each month or not showing it at all.
I want to see all months together but from Jan to Aug i want see only actual and budget and then from Sep to Dec I want to see Actual , Budget and Forecast.
Thanks in advance 🙂
I have uploaded the example, How the output should look like.