I have a drill down dimension that breaks down data based on a company hierarchy of its divisions.
I want to use a variable that has buttons to view charts based on which view you select on the button. I created a variable called vSALESVIEW and created a variable input visual with buttons, set on dynamic with options ='DIVISION DRILL THROUGH|CONTRACT|PF_CONCAT'
The I set the dimension in the chart to be =[$(vSALESVIEW)], and the measure seems to work correctly when "contract" or "Pf_concat" are selected as those are single dimensions. but the DIVISION DRILL THROUGH is not working. I would like it to work where i can drill through the divisions like I could if it was its own dimension, but when a button is selected.
I would just add the drill through dimension as a second dimension and then use the calculation conditions of both dimensions to switch to the drill though whenever your vSALESVIEW variable has the drill through selected.
