5 Replies Latest reply on Jan 7, 2014 11:30 AM by Aaron Clancy

    Select individual items in a crosstab / heatmap

    Kurt Heisler

      I'm using Jonathan's excellent conditional formatting technique (Crosstab of Many Colors) to mimic a heat map while allowing me to format each column separately (e.g., separate color scales, % vs. numbers, etc.).

       

      I'd like to allow the user to select which "columns" or measures to show/hide via a multiple values option list. Given the way the table is created, the default quick filter approach doesn't work. As you can see in the screenshot below, unselected items still appear as a column and with all null values. Any suggestions?

       

      Workbook is attached. Thank you for any pointers.

       

      screenshot.jpg