4 Replies Latest reply: Aug 26, 2016 10:46 AM by John Cavoulas RSS

    Best way to display multiple tables with same field filtered differently?

    Chuck Pechmann

      I am looking at creating an executive dashboard that has three tables, all on one sheet, with each table having the same field filtered differently.

       

      For example: I would like to create three identically looking tables that display total sales by region and market for each month of the year. In the top table, I would like to show sales for all channels. The middle table would be only for sales that came through a specific sales channel (for example: the internet). The bottom table would be for sales that came through all other sales channels (for example: all channels except the internet). Other available filters would allow leadership to filter on other fields, such as: product category, product, customer, etcetera.

       

      Thanks for any insights