Forum Discussion
New column
Hi, I have a table with different measures and columns, including columns account number, account group, and a measure called Totalsum. I want to add a column called Income with the following 4-row ...
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 I have other groups that are not mentioned in my post. as Group4, Group5, Group6, and AllGroup2 -> which is the sum of Group4, Group5 and Group6 So if I use total in the visualization it will give me the sum of all groups, not the sum under every third group.