I am not sure that the "expected results" should be what you show based on the table you have.
First of all you also have triplicates not only duplicates....
However a load script that will give you a list of the number of similar occurrences higher than 1:
DATA: LOAD * WHERE N > 1; LOAD SUPPLIER, DEPARTMENT, TOTAL_PO_AMT, Count(RowNo()) AS N INLINE [ PO_NO SUPPLIER DEPARTMENT AMT TOTAL_PO_AMT XX9280 SHOEMART-A SCIENCE 5000 10000 XX9280 SHOEMART-A SCIENCE 5000 10000 XX9281 SHOEMART-A SCIENCE 10000 10000 XX9282 SHOEMART-A CHEMISTRY 5000 5000 XX9283 SHOEMART-B COMPUTER 1000 5000 XX9283 SHOEMART-B COMPUTER 4000 5000 XX9284 SHOEMART-B COMPUTER 2000 2000 XX9285 SHOEMART-B COMPUTER 2000 2000 XX9286 SHOEMART-B COMPUTER 2000 2000 XX9287 SHOEMART-B SCIENCE 2000 2000 XX9288 SHOEMART-C CHEMISTRY 5000 5000 XX9289 SHOEMART-C SCIENCE 10000 10000 ] (delimiter is spaces) GROUP BY SUPPLIER, DEPARTMENT, TOTAL_PO_AMT ;
Thank you for your prompt reply. Sorry for my bad english , I mean to say similar records (SUPPLIER, DEPARTMENT AND AMT]. Honestly, these could be more as I'm checking for X financial years of reports.
Thank you for the load script count() you've advised earlier. What i did is i declare a new dimension for the similar fields and count the similar in another load script:
And then, created measures to filter the count I need.
Thank you and have a great day!