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:




      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




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


          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





          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.