Hi
My data looks like below. I desire to have a view where in based on my selection of timekey i get table2 view as shown below :
Timekey | Var_A | Var_B |
Apr-17 | 1 | 4 |
May-17 | 2 | 4 |
Jun-17 | 3 | 4 |
Jul-17 | 4 | 6 |
Aug-17 | 4 | 6 |
Sep-17 | 4 | 7 |
Oct-17 | 6 | 8 |
ID | | Apr-17 | May-17 |
1 | Var_A | 1 | 2 |
2 | Var_B | 4 | 4 |
Help will be highly appreciated.