I have a table that I use for forecasting that I want to slice base on the selection of static v live.
I have the FF items (YTD, MTD, Stat BL, Stat PL, Live BL, Live PL) are in the item column of my data set.
For a live selection, I want to return (YTD, MTD, Live BL, Live PL) and for Static View (YTD, Stat BL, Stat PL)
I want my selection to only show live or static as the options. I have attached a pic of what I would live to see.