I am stuck and getting wrong value.
I am use filter option of the report.
Report 1 is of region data (India, China, England) and report 2 has data just for India metro (delhi, mumbai, chennai, banglore)
Report is working fine but when i select India graph and use as filter and when i deselect the filter report 2 start showing data metro of all regions.
Yes, It will filter based on selection and once india selected then india data will display, once deselected then it will show all data.
Please update work book.
What you want to show in each sheet and what you want to get deselected time.
Are you expect to show only india data in sheet 2 always.