This content has been marked as final. Show 2 replies
I need it working in the following scenarios:
- I need the filter so that By Default the total includes O+C+R (excluding FCC and Inv).
- If I select O/C/R, respective totals for domains should be displayed.
- If I select FCC/Inv, respective totals for domains should be displayed.
- If selection is removed from Sheet 1, total should include only O+C+R (excluding FCC and Inv)
I am able to achieve the first 3 in my sample attached. However, once the selection is removed, the totals are including O+C+R+FCC+INV
Can you suggest anyway to fix this?