Forum Discussion
Adding Visuals Together
- 3 years ago
Philmo123 , You need to create a new column and use that on axis
Switch( True() ,
[Column] in {"Civils", "TRR"} , "CivilsTRR",
[Column]
)
Thanks for coming back to me v-xiaotang but I don;t think so.
I have 5 different code groups. Within those 5 code groups i have TRR, Civils, UG, OH and Poles.
For each code group there is a quantity and has a summation sign against on the data.. So codes groups 1-5 have CodeQty1-5. Which matches the bar chart as seen on the first message on this forum.
I need to be able to sum these values from each Code group.
If I merge onto one visual, the filters cancel each other out. They have to act independently in order for me to get the total of all TRR within code groups 1-5, and Civils, etc.
I.e Code Group 1 - Civils - 70291
Code Group 2 - Civils - 42186
Code Group 3 - Civils - 13050
Code Group 4 - Civils - 8284
Code Group 5 - Civils - 305
I need to add these together and sum them into a total.
How do i do that, and can I?
Thanks
Phil