300, BB, SAP, UK, IT 400, CC, IBM, IN, IT 500, ZZ, Microsoft, FR, HR ];
My main requirement is to show Sales data in a straight table and its corresponding P_ID(may be in expression).
This above case i assume only P_ID- 400 will be shown in straight table as it is only row common between both tables.
However i want to display other P_ID's that are less common as well if a selection is made. What i mean is, if a user select Product- AA, then show P_ID - 200 along the below rows and similarly if System- SAP is selected by user, show P_ID- 300.
AA, SAP, DE, Manufacturing,
AA, Oracle, US, IT
I am not sure if straight table a good option for my requirement, but if there is better option, please guide me.