Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Set Analysis: Sum({<[Yes/No]={'Yes'},Operador=>}(Kg.Neto))
Hi,
try Sum(Distinct(Pauta)) and Sum(Distinct([Kg. Neto]))
Hi Tereza, i've tried your solution, but i got this i need to sum only one value for each field "pauta"
straight or pivot table
dimension: Pauta
expression: Sum(Distinct [Kg. Neto])
Marco, thanks for your help, but that doesn't solve the problem, i've tried that before, but if there's 2 "pauta" with the same value on Kg.Neto, only one value Kg.neto is going to be considered. And with dimension, i need to show the dimension "operador" because that's the zone of the country that i want to show.
I don't see the value for "operador" in the table above, so it's touch to come up with a sample.
See attached picture with example
You have to explain your data model and expected result.
If Pauta is a dimension then two equal kg.neto values will be considered for their respective pauta values even if you sum only distinct kg.neto values.
Maybe someone more examples could help.
regards
Marco
Ok, i'll try to explain with an example on excel.
So, what i have to show on the straight/pivot table its the sum of only unique valors like i show on the table to the right. I hope i've explained this well xD. Thanks!
(Pauta is not a dimension, only "Operador" is a dimension)
Set Analysis: Sum({<[Yes/No]={'Yes'},Operador=>}(Kg.Neto))