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.
I hope that you can understand what im trying to do.
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.
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.
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)