Forum Discussion
Maximo Purchase Order data filters
Hi all, I can usually find answers to everything on the Google machine, but this has me stumped. Purchase Orders can contain Line Types of Services, Materials, Items, or a mix of both Materi...
Hi bhold32078 ,
You could create a measure like the following codes.
Measure =
IF (
"Item" IN VALUES ( POLINE[LINETYPE] )
&& "MATERIAL" IN VALUES ( POLINE[LINETYPE] ),
1,
0
)Then put it into filter pane of your table visual and make it showing 1.
Hi v-eachen-msft,
This formula includes purchase orders with either MATERIAL or ITEM ordered against them, which is a big list.
I'm looking for a filter that narrow it to purchase orders that have both MATERIALS and ITEMS ordered againsts a single purchase order, which should be a much smaller list.
I appreciate your help.