I need help with sum on qlikview

[#1]

Hi community! i've been working on a way to show a dashboard on qv, but i'm having some problems with the data im using, so i need some help to get the results that i need.

I have this table, and i need to make a formula that ONLY sums one value for field "Pauta" so when i make a sum, i only get.

Pauta          Kg.Neto
252292        677,42

252293        290,8

Total           968,22

I hope that you can understand what im trying to do.

Thx!

[terezagr]

Sorry, forgot to attach picture with data that I have used:

[#3]

I'm going to try that, thanks TerezaGr!

[terezagr]

No problem! Happy to help.

Please let me know if it works for you!

T.

[#5]

Thanks TerezaGr, that was the answer

I have a new question with QV, should i create a new topic or just ask in this one?

[terezagr]

Open a new topic. That way people will reply to you faster.

Have a good day.

T.