Re: Dimension: Union of 2 Columns

Hi Kaushik,

Thanks for your reply, however I don't understand your answer - If I were to concatenate the 1st row in the sample table the result would be "ApplesOranges" 1 - this isn't the desired result. Or am I misinterpreted your answer?

Re: Dimension: Union of 2 Columns

If you the combination and order of FruitA and FruitB matters, than you can concatenated the columns, as you mentioned ("Apples|Oranges" rather than "ApplesOranges"), calculate the percentage, afterwhile arrange the columns, with the manner in my and Kaushik previus comment.