Can't manage to sum a calculation

[aheavy95]

Hi all 

I have a problem with one of the calculations in my straight table.

The field internal use is calculated like this:   =if(Internal_Use>0,Internal_Use,0)

It is an already summed field.

For some reason it shows me only the unique values of the internal use field (1,3)

Only when I add the Date field I get the whole records:

My goal is to get the sum of the records which for this product in 2022 is 8, and not each row seperately. 

Anyone has an idea?

Thanks

Alon

[BrunPierre]

What is the expected  O/P?

[Fernando_Fabregas]

Hi!

In your table, add a column as Measure, with:

Sum(Internal_Use)

Tables in Qlik group dimensions and show only one row per distinct value.

If you need to show the same rows as is in your model, you will need to add more columns, like a unique ID or RowNo().

Regards, Fernando