Can you attach a sample workbook
Firstly thanks for going thru my Question and reverting.
I have attached sample workbook.
In the attached workbook you will see Central and South proportion of sales being 56% and 44% which actually is not am expecting to show. Since i have couple of regions hidden using data source filter which also occupies proportion of sales %.
I am expecting the output to show its total % including the values hidden in data source filter (i.e., East and West).
Expected output: Central = 22%
South = 17%.
and not Central = 56%
South = 44%.
Please look into this and let me know if you have any workaround on this.
Thx 1ce again!