changing variables based on the container selection
Hello all
I have created a page which has 3 different pivot tables in a container and a table underneath which provides detailed information about the cases in the pivot table. I am struggling to get the table underneath to change on the 3 different pivot tables.
I think i need to create a variable (or will it be 3?) in the load script which will change depending on the container the user selects. I would then use an IF statement containing the variable for the measure of a particular field.
I am not sure if its possible to change a variable depending on the container view? Any help appreciated.
How are you navigating 3 diff pivot tbales? do you have a variable that stores the object id underneath the button you hit, let say vTab=1 when button 1 i hit vTab = 2 when button is hit and so on?
@MB2024 What do you want to change in pivot table? If I understood it correctly, you want to create variable depending on pivot table you select from container so that you can put some condition in pivot table. Is that correct? If so you can create three buttons or variable input button on which you can set the variable value on click. In container then you can show or hide you pivot table using variable value from button click. You can also use that variable in corresponding pivot table. In summary, show or hide pivot table based on variable value from button and use that variable in pivot table field condition.
