Tableau Lod

Hi Please check below sample data ,if user select Region =A  and Country=INDIA by filter we need to show B,C total in sheet 2 (Mean need to exclude C) and same thing we need to map sheet 1

sheet 1 is with Region =C and Sheet 2 is without Region =C Ex is below

attached is sample excel data with same example please check

Sheet 1 is actual data based on filtered data

Sheet 2 is Excluding data based on filtered data