1 Reply Latest reply on Mar 13, 2018 9:17 AM by Jim Dehner

    Find last payment of each member

    Raheel Farooq

      Hi All,

      I am new to tableau and need some assistance to create a measures

       

      I have 3fields i.e. member_id, Payment_Made(Amount), Date_of_Payment.

       

      I want to display tabular data in the format like below:

       

      Member_IDTotal_Payments_made_till_DateLast_Payment_Made

       

      So I have to create 2 new measure i.e. Total_Payments_made_till_Date and Last_Payment_Made

       

       

      Could you kindly share what and how i can achieve this. Thankyou

       

      Regards,

      RF

        • 1. Re: Find last payment of each member
          Jim Dehner

          hi

          welcome to tableau

          see the attached - it is one way to solve the issue

           

          the data is superstore data

          first the last order for each customer is

           

           

          then create a filter like this

           

          place it on the filter shelf and set to true

           

          and the viz returns this

           

           

          Jim

           

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.