Can you post a twbx file?
You can manipule totals using IF Size() statements.
Probably If Size() = 0 then new calculation else ...
For checking this properly create a calculation Size() and drag on row shelf.
Thanks, I attached the twbx.
Great, thanks a lot!
That was a great wrap up to the visualization, but I need to work further on this calculated field.
I will, for example, apply a 8,5% rate over this value, for some products, then apply 12% rate over other products.
Instead of use the acquisition value I would always use the Avg value for different calculations. It's a preparation for the real analysis.
Any other sugestions different than that?