I want to create a brand new dimension called "Target" for each measure, how do I do that? Say for A, I want Target = 30, C, Target = 10, Ca, Target = 80%....as a dimension. I do not have control to the underlying data.
The data needs to be added to the data source since the new column wants to be made from three different measures.
Retrieving data ...