I have a table containing a list of partnumbers, supplier of that part number, to what store and the vendor partno which is different from ours.
In this case two suppliers deliver three different partno but we sell it as the same. As you can see in the example below one supplier has two part numbers for our part no and we want to catch those errors.
Partno Store Supplier Sup.Partno
1000 1 A 37
1000 2 A 37
1000 1 A 38
1000 1 B 76
i have a pivot table
with the dimensions
and the expression
count(Sup.Partno) because i want to see how many occurences there are (=how many stores have that partno)
In my pivot table i want to show only suppliers that have two partno for one of ours and not show the others.
By checking out the community I thought that my dimension expression would work but it didn't and I would like some help.
I have attached a qvw for you to try. In the right one "A with aggr()" all are visible. But if you click 0101 it shows nothing because the expression doesn't apply after the selection. But according to me it doesn't apply before but it still shows all Partno. I'm missing something. I also included the an extended version of the inline example for you convenience.
Because 1005 has two vendor part numbers for one of ours. And we don't want doubles. It would be problematic to if we bought two different products from a vendor and sold them as the same. Therefore I want to catch the suppliers who have several vendor_part_no for one of our partno.