This challenge looks very simple. If you try to solve
then you will understand what’s the challenge here.
Use Super Store dataset to solve this challenge.
I have 4 filters in above chart. If I change Year, Segment
and Category Then Sales and profit values will change. But if I unselect any of
value or values from Sub-Category filter then Profit will become Zero. Only
sales numbers will change. See below
In above scenario, I only changed Year, Segment, and
Category filters. Sub-Category filter showing all selected. If I change
Sub-Category filter, then Profit should be zero. See below
Here challenge is simple. When you select all values
in Sub-Category then profit should show. If you unselect single or multiple values,
then profit should be zero. Very interesting challenge try it.
Example 1:
Example 2:
Example 3: