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.