Dynamic MTD and YTD slicer using YTD Data
I have provided a sample data where I have the Actual YTD data (Actual, Plan, Prior Year) by period for a city. Suppose I select Period 6, I want a slicer to switch between MTD and YTD data.
I have provided a sample data where I have the Actual YTD data (Actual, Plan, Prior Year) by period for a city. Suppose I select Period 6, I want a slicer to switch between MTD and YTD data.