If you need this. Then Create a Filter Calc , Drag it to Filter Shelf and Set TRUE.

Thanks

Deepak

If it Helps, pl mark it Helpful and CORRECT to Close Thread.

Hi Emrick,

There seems to be a few different questions here, so I built a set of sample calcs to answer them separately.

First month of activity for a given "A"

From there, we can find the Amount in their first month of activity....

As well as the number of new "A"s that started in a given month

My workbook is attached so you can see each calculation and result.  Hope this helps!

- Jim

There are few ways to do that. I have used 2. So you can select whatever you need. pl see attached

Thanks

Deepak

If this Answers, Please Mark my Reply as Helpful and  CORRECT to close Thread

Welcome!! If it worked, Please Close Thread.

You're welcome.  Good luck!

Which version of Tableau desktop are you using?  It's built in 10.4, but I can save it back if need be.

Ok, see if this works.

I had to save it as a TWB to go back to 10.1, so I am also attaching the data spreadsheet I used.