Thanks for the response....the issue I have though is that the two values I want to combine live in the same dimension.
The current dimension has 2 values and I want to create a 3rd value by combining the already existing 2 values of the dimension.
Hi Brian, this will be a couple of steps more.
You need to create 2 calculated fields in the following format:
if [field] = "value 1" then [number of records or whatever measure you are using] end
then combine the calculated fields using the same logic as above
[calculated field 1] + [calculated field 2]
I'd still like to show the individual breakouts. A filter would ideally show DC1, DC2, Both (or something like that).I want to see who has DC1 with the amount, who has DC2 with the amount, and then who has DC1 and DC2 with respective amounts.