1 of 1 people found this helpful
Leaving your channels and other calcs as they are, I have added a WINDOW_SUM to add up the three separate values. I think you need to keep channels on the sheet, and have your three separate calcs as you have them, but you MIGHT be able to simplify this and just sum up everything in one swoop. I'm not sure and I don't have the time to dig in.
So I do a WINDOW_SUM of the V3 calc, and tell it to run along Channels. That gives me the right value, but because there are three marks (one per channel), we get 3 duplicates of the value. Go to copy 2. Here I just moved the V3 calc to details. Go to copy 3. Here I added an extra calc called index, and also ran it along channels so we get 1,2,3 in the respective marks.
On copy 4 I dragged [index] from text to filters and selected only for value = 1. Now we get a single value. You can clean up formatting as you see fit.
Thanks this did the trick. I'm glad you didn't need to dig in to the rats nest of calculations and thought of a clever way to just get the sum.