Hello there!
I need to add a calculated field in order to know the percentages of that represent each table above “Net Total PAX”.
How should I run the formula?
Thanks!
It would be helpful if you could share where the numbers in the different score cards comes from, are they different fields in your date or are you using filters to create them?
If you are using different columns you can use “Add Field” and Sum(Pax_a)/Sum(Pax_a)+Sum(Pax_b) etc
If you are using filters you can create a blends combining the filtered score card and the unfiltered one and then “Add calculated field” and Sum(Pax_filtered_scorecard)/Sum(unfiltered_scorecard)
