9 Replies Latest reply: Apr 26, 2016 7:29 AM by Sangram Reddy RSS

    Show different fields based on a selection?

    Tanya Ruppell

      Hi,

       

      I have data that looks something like this:

       

      LocationWeekday visitorsWeekend visitorsWeekday salesWeekend Sales
      A1234620
      B1621103
      C1532315
      D1745825

       

      I would like to be able to have a single chart table that shows all the locations, but displays either the Weekday stats or the weekend stats based based on a user selection.

       

      So it would be something like this:

       

      Weekday Stats

      Weekend Stats

      (some way for a user to select between the two)

       

      LocationVisitorsSales
      A126
      B1610
      C153
      D178

       

      Is this possible? Perhaps I need to do something when I load the data?

       

      Thanks.