Reporting Services :: Report Builder - Set Parameter To Include Or Exclude Columns From Data Presentation

Based on a table like below I have created a report so that I can compare number of items in the main warehouse (LOCATION1) and the outlets (LOCATION2 and LOCATION3).

___________________________________
| ID | PRODUCT_INDEX | LOCATION   | VALUE |
___________________________________
| 1  | INDEX1             | LOCATION1 | 1         |
___________________________________
| 2  | INDEX1             | LOCATION2 | 1         |
___________________________________
| 3  | INDEX1             | LOCATION3 | 0         |
___________________________________
| 4  | INDEX2             | LOCATION1 | 0         |
___________________________________
| 5  | INDEX2             | LOCATION2 | 0         |
___________________________________
| 6  | INDEX2             | LOCATION3 | 1         |
___________________________________
| 7  | INDEX3             | LOCATION1 | 1         |
___________________________________
| 8  | INDEX3             | LOCATION2 | 0         |
___________________________________
| 9  | INDEX3             | LOCATION3 | 1         |
___________________________________

The way I present data in my Report is as such. I want to show items that are available in the warehouse that should be moved to the outlets.

select 
 a.PRODUCT_INDEX
, a.LOCATION1(VALUE)
, b.LOCATION2(VALUE)
, c.LOCATION3(VALUE)  
from 

[Code] .....

__________________________________________________________________
| PRODUCT_INDEX | LOCATION1 (VALUE) | LOCATION2 (VALUE) | LOCATION3 (VALUE)|
__________________________________________________________________
| INDEX1               | 0                              | 1                               | 0                             |
__________________________________________________________________
| INDEX2               | 1                              | 0                               | 1                             |
__________________________________________________________________
| INDEX3               | 1                              | 0                               | 1                             |
__________________________________________________________________

I have added some parameters in my report to filter out products that are not available in warehouse (LOCATION1) and this works great.

select * from VIEW where 'LOCATION1(VALUE)' > 0 and ('LOCATION2(VALUE)' = 0 or 'LOCATION3(VALUE)' = 0)

__________________________________________________________________
| PRODUCT_INDEX | LOCATION1 (VALUE) | LOCATION2 (VALUE) | LOCATION3 (VALUE)|
__________________________________________________________________
| INDEX1               | 1                              | 1                               | 0                             |
__________________________________________________________________
| INDEX3               | 1                              | 0                               | 1                             |
__________________________________________________________________

Now the issue starts when I add a parameter to my report for user to choose which outlets (LOCATIONs) he wants in the equation. I know how to make a column disappear based on parameter value but how to take it out of equation? At the moment when user selects only LOCATION2 and not LOCATION3 then data is not filtered correctly:

__________________________________________________
| JOIN_ON_VALUES | LOCATION1 (VALUE) | LOCATION2 (VALUE) |
__________________________________________________
| INDEX1                 | 1                              | 1          |
__________________________________________________
| INDEX3                 | 1                              | 0          |
__________________________________________________

Ideally I would like a user to select random outlets (warehouse would be static on the report) and compare one or multiple and only show records that are 0 in the outlets.