Show all Products

[spividori]

Hi.

In my model, I select a set of "Codigo" and then I need to select 1, 2 or 3 "Imputacion" and when doing the "Imputacion" filter, in the "Cantidades" table it does not show me the "Codigo" that did not have data, but I need you to show me only from the set of "Codigo" selected.
Attached exampled.

Regards.

[lironbaram]

hi 

if you want to disregard selections in the field Imputacion

just change your expression to 

Sum({<Imputacion=>}Cantidad)

[sunny_talwar · Accepted solution]

It is a hack, but might work for you

Sum(Cantidad) + If(Len(Trim(Only(TOTAL <Imputacion> Imputacion))) > 0, Sum({<Imputacion>} TOTAL <Codigo> 0.000000001))