1 Reply Latest reply on Oct 19, 2016 7:29 AM by lenaic.ridinger

    Heat Map Rank by Row

    Bob Snyder

      Hi All,

       

      I want to create a heatmap that only applies to a specific row. While some have answered this question in the past, I am not seeing a clear cut way to do it.

       

      I have Customer on the Y axis, Quarter on the X axis and measure is Shipment Quantity (only 5 quarters of data).

       

      When I drop Shipment Quantity onto the Color Pill and make it a diverging Green to Red heatmap, it works across all shipments instead of at a customer level.

       

      I know what i'm trying to do is possible, but could someone provide a step by step?

       

      I have attached the superstore example, illustrating what I currently have set up in my workbook.

       

       

      thanks in advance!