I have created calculation with respect to few Customers.
What I did is, Date difference between First Order Date and today.
The following link will help you for your situation.
Thanks for the reply
As mentioned in my initial post i would not like to have my id's or dates in my view as i am showing aggregated data based on the field called "Source"
If I place id in my view i can achieve what i am trying to but the client want it other way with only source as a breakdown
please check my sample workbook attached may be u get what i am trying to achieve
Sorry I forgot to mention that my current version is tableau 8.3
I am using Tableau Public at my Office, so i can't download & Use your Workbook. So Publish your workbook to Tableau Public & send the Link.
I am guessing this point will help you, If you don't want to show IDs on the report, right click on that column in the view, click on "Show Header" then this column will be hidden from report but it is part of Report.