Forum Discussion
Adding Visuals Together
Philmo123 , You need to create a new column and use that on axis
Switch( True() ,
[Column] in {"Civils", "TRR"} , "CivilsTRR",
[Column]
)
Philmo123 , You need to create a new column and use that on axis
Switch( True() ,
[Column] in {"Civils", "TRR"} , "CivilsTRR",
[Column]
)
Thankyou amitchandak but i'm a little confused.
Where am i adding the new column to?
I have made 5 sets of groups. Each group has a code qty field affiliated with them (Code Group 1 goes with codeqty1, then 2, then 3, etc)
So in order to get the value correct of all Civils in Code Group 1,2,3,4 & 5, i need to be ab able to sum all the values independently to get the true value.
Would the solution above allow that, and if so, where am I adding the column? DO i need to change from bar chart to table to do a SUMX? I just need to sum the values for each group 1-5 to summarise it.
Thanks