I have a table where I have 3 dimensions: CTR, email open and Inbound calls.
The 2 measures that I have are based on some calculation. In gross results I want the results from Excel A to get populated while in Lift Results I want the results from Excel B. The problem is that both the excels have the same field names and I cannot change them.
I have a filter pane from where I want to select say excel A and see the results in Gross Results and another filter pane through which I want to select excel B and see the results in Lift Results. how can I do this?