dynamic column selection based on slicer

Hi All,

I have a scenario where i need to select column (not measure) based on the slicer. 

Example:

Table1:

I have a table with country and state level sales and profit

Table2: 

I will have a slicer where it says 

Country

State

Now if i select country in slicer, i need the sales in country level and if i select state in slicer i need sales in state level. 

I know this kind of selection is possible with measures as below,

Val selection = IF(HASONEVALUE(Table3[Col_selection]), SWITCH(VALUES(Table3[Col_selection]),"Profit",SUM(Table1[Profit]),"Sales",SUM(Table1[Sales])),0)

//Here profit or sales gets selected based on slicer(table3). 

I'm looking for something similar, but with columns.  

Thanks in Advance,

Berin.