Displaying only last occurance

[#1]

Hi,

please see example.

could you tell me how to do this? 

[#2]

No ideas?

[#3]

Still nothing. Mayby somebody have idea how to show it in another table? Table should contain only information about PO Number and month, when first transaction occur.

[jagan]

Hi Tichan,

I didn't seen any script in the attached file.  This can be easily done in script.

In your load script you order the data by PO Number and Month in Desc order, and add an extra column(flag) to mark the row as last occurance row.

The additional column script is

If([PO Number] <> Previous([PO Number]), 1, 0) AS IsLastOccurance

Now, in the table using set analysis  {<IsLastOccurance={1}>} you can display only last occurance row.

Regards,

Jagan.