Forum Discussion
New column
Anonymous Your calculation seems to be weird. It is like you are trying to return two values for the same row in the same column, both "Group1" and "All Groups". You can't do that, a row in a column can only have a single value, either "Group1" or "All Groups".
Greg_Deckler Thanks for your reply!
Yes, that's the problem I am having. Is there any other way to do this?
Anonymous Not the way you are doing it, no. You could use 2 columns, one that has the Group1, Group2, etc. and the other that has like All Groups and Other Groups (or just blank). Or you could do it in the measure itself or the disconnected table trick as originally mentioned. But, no, you cannot magically insert two different values into the same row and column (cell) of a table. That would require quantum physics.