Forum Discussion
merge rows?!
I have quotes that pass through s1 and s9 (s9 means the quote was cancelled because its a duplicate) the rows "count of s1" and "count of s9" are measures. I want to remove any quotes that had ...
Hey Anonymous
Please provide a sample data that can be copied and pasted.
Cheers!
A
Anonymous I am not sure how to do that as it is live data, is there any way i can show it to you without the relationships?
Anonymous
Down and dirty trick . . . create a column to add the S1 column to the S9 Column and filter out the 2s in your new column, then perform your merge if you just want to remove the ones with both and S1 and an S9.
Not elegant but if it works . . .
