1 Reply Latest reply on Jul 17, 2018 7:58 AM by Jim Van Sistine

    Percentage of Total

    Megha Bhatnagar

      Hi,
      I need to create summary Statistics using some data. I need to know the number of AMZ and Warehouse as a percentage of Total as a whole. I used the quick table calculation to do so. The problem is when I use the sheet on a dashboard and only select 1 DMA the percentage changes to 100 instead of the original value.

      I have used LOD in the past to fix these issues but running into issues today.

      I am attaching a mock workbook for reference.