1 Reply Latest reply on Jul 4, 2018 10:29 AM by Anna H. Dzikowska

    Filtering a sheet

    Andrew Gorsuch

      I have created a sheet that uses the same data twice (connected twice), so that I can filter each and show a duel chart. The first set of data is filtered to show average usage of a system in a specific region (NA West) and the second connection is to show average usage of all the areas. Show the average of each region vs the average of all regions. When I go to filter the second connection it doesn't work and gives me an error. Is there a reason why it won't let me blend? If I make the connections of the region then it filters connections by the same region. Attached are pictures, as I cannot attach the file.

       

      Thanks