Display Latest Transaction details of a Customer


I have a report where I display the Customer Data with latest Transaction Date

For ex:

Existing Data

Cust_Num Name Txn_Date
1 A 01-Jan-19
1 A 01-Mar-19
2 B 01-Jan-19
2 B 01-Jan-19
2 B 01-Sep-19

Data to be displayed

Cust_Num Name Txn_Date
1 A 01-Mar-19
2 B 01-Sep-19

Please suggest some method to achieve this.

Am using Tabular Report, Incorta Version 4.2.12



1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi,


    Try this:

    1.Create an aggregate insight

    2.Add Cust_num and Name in Grouping Dimension

    3.Add transaction Date in Measures section

    4. select aggregation as "MAX".


    This should do.


    Thanks and let me know how it goes.

Like Follow
  • 2 yrs agoLast active
  • 1Replies
  • 13Views
  • 2 Following

Product Announcement

A new community experience is coming! If you would like to have beta access to provide feedback, please contact us at community@incorta.com.