Create a Slicer based on data from 2 columns

Hello All,

I would like to create a slicer which will be based on 2 columns. For example sample data and how the slicer should look like is shown below.

Sample data:

Slicer: will be based on columns "Type A" and "Type B" such that when I select "Type A" it will display the values for all the cities for type A. If I select "Type B" it should display values of cities for type B and if i select both "Type A" and "Type B" then it should sum the values. Scenarios outlined below:

Scenario 1: Type A selected

Table will display:

Scenario 2: Same  as scenario 1 when type B is  selected.

Scenario 3: when both Type A and Type B are selected

Table shows:

Thanks in advance!