2 Replies Latest reply on Aug 2, 2018 2:12 PM by kate summer

    How to make the highlight of dimension cells disappear after adding subtotals

    kate summer

      Hi,

       

      I highlight one dimension (region) and need to add subtotals. After adding the subtotal, a colored "All" shows up. How to make the 'All' Cell (circled in the image) as a blank cell - no value and no color? A sample workbook is attached.

       

      Capture3.JPG

       

      Thank you for any help!

       

      Kate