8 Replies Latest reply on Apr 25, 2016 1:55 AM by Allen Gapara

    Child to control Parent parameters

    Allen Gapara

      I am running out of ideas with the following. On the Dashboard, I have a venue parameter and a region parameter. Of all the sheets, you can either  choose a region or a venue to show the statistics. On only one sheet, I want to compare the region statistics for that venue. It should only show the region where the venue is located. 

       

      If I make the venue parameter control all the sheets, then on the region sheet it shows me the venue stats not the region. On the region sheet, if I remove venue and use only region, it shows all the regions.

       

      Please help me, sort this out. Select venue,  and on the region sheet it picks the region only. I have tried case statement to select region, but they are boolean type, string errors. I have attached a sample work work.