SUM in TABLE

[JorgeFra81]

Hi,

I am trying to get a sum inside a TABLE. But I could not get the desired result.

I have tried these options:

Dimension: PAX_TOTAL_DEPARTURE 

Measure_ =Sum(PAX_TOTAL_DEPARTURE)

What I need is when I filter by Base I would like to obtain the Sum of the PAX_TOTAL_DEPARTURE by Base, but I only got the total number of PAX, same numbers for all Bases and it shouldn't be.

I will really appreciatte any help

[dplr-rn]

why do you have PAX_TOTAL_DEPARTURE  as a dimension?

[JorgeFra81]

Hi, 

In the second picture I have it as measure. I just said I have tried both cases.

Dimensión:Expression

Medida:Measure

[dplr-rn]

hard to diagnose with out more detail

but when a simple sum(column) shows full today that means an issue in the data model i.e. that column PAX_TOTAL_SALIDA is not related to other columns in that table

[JorgeFra81]

I just made a translation for you.

It is better that you take a look at the qvf file BAGGAGE, and the sheet BAGGAGE RATIO.

Thanks for your time!

[JorgeFra81]

Maybe I have to use another kind of function.

[Kirsten]

If you click on the table, on the right side under Data: if you click on a measure and it opens up you can set the Totals function on SUM

See attachment. Does this work?

[JorgeFra81]

Hi Kirsten,

I havve checked and it is on AUTO for Total Function.

[Kirsten]

ok is the issue herewith resolved?

[JorgeFra81]

I am afraid it is not solved.

I should get this kind of results:

To obtain these results I have inserted this table, but this is all the results tipped by me.

🤔