Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
in the app, I have multiple fields as filters.
fields 'Version' and 'Carrier' will be selected. I need to keep field 'Version' (and selections from other fields) & ignore selection in 'Carrier' completely to calculate TotalTEU. Please help to calculate TotalTEU.
| POL | Carrier | Version | CntrTEU | TotalTEU |
| Naples | AAA | 2020 | 200 | 300 |
| Naples | BBB | 2020 | 100 | 300 |
calculating Cntr TEU with this expression:
sum(aggr(([CntrTEU]),[CntrSeal]))
thank you
thank you for your time. These are the outputs I get.
the output I require is table 1 but even when selection is made in 'carrier'.
shippedTEU column is calculated with this expression: sum(aggr(([CntrTEU]),[CntrSeal]))