thanks for the answer.
but I don't understand why does its show all the sales for each part even when I select a custname
because the custname= means disregard of custname selection?
in your solution,
I don't see why its not show the whole sales even when I select custname. ?
the set analysis in the expression means there is no select in the field custname.
Sorry, I don't get what you want.
In my solution, when you select customer x, you'll see
You'll see a row for part e like requested, and the sum(quant) is zero, because the customer x doesn't have any records for this part. I assumed this is what you want to see. If not, please clarify what the expected result is when selecting customer x.
Right, the set expression will ignore your selection.
But do you still have an issue? Sorry, I don't really get your latest requests.
As you see, I am using two expressions, one without set analysis to show the values for your selection, and a hidden expression with set analysis to extend the rows to the ones without sales (this one ignores selection in customer).
ok, now I understood it.
you add a hidden expression, well this is not good because I need it in a pivot table,
and there I cant hide expression.
the real problem here is the flag "is_pl", when is_pl=1 its cuts the rows
for those items the customer bought and then we loose item "e"