8 Replies Latest reply on Jul 12, 2018 11:18 AM by Hamza Alsalman

# finding max 3

Hello I have a question about find max 3 customers.

I have this formula: RUNNING_SUM(IF [open_dt]>=([max date]-59) then [Curr Bal Amt] END)

I want to calculate a sum of balances over the past 60 days by (prod dt)<---this is my field for every day I have data

I also have another field called open dt which tells me if an account was opened.

I would like to calculate total [curr bal amt] if the acct was opened in the last 60 days and only show the top 3 customers with the highest balance.

Unfortunately I cannot offer any sample data as it is all sensitive data. Thank you!

• ###### 1. Re: finding max 3

Hamza,

As Earlier Can you create a sample Excel Dataset to help you fast showing what you need.

Thanks

Deepak

• ###### 2. Re: finding max 3

Hey Deepak,

Thanks for your help once again . please find the excel sheet attatched

Thanks,

Hamza

• ###### 3. Re: finding max 3

Also I created a formula called max date that gives me the maximum date available in my data set.  I must only check 60 days behind this date for open dt and then balance amount.

• ###### 4. Re: finding max 3

Pl Check:, Only One value falls in your sample range. Apply it to your actual data and Rank it and get Top 3

Thanks

Deepak

If it Helps, pl mark it Helpful and CORRECT to close Thread

• ###### 5. Re: finding max 3

hey Deepak,

How do I rank the top 3 customers. I only want to show account name. Also since I have more production dates is there a way to show the top 3 based on the total (from the analytics tool in the top left hand corner)

Thanks,

Hamza

• ###### 6. Re: finding max 3

Rank_Unique(SUM(If Calculation 1 Then Current Balance END)), when you get the Ranks Then filter for Top 3

1 of 1 people found this helpful
• ###### 7. Re: finding max 3

Hey Deepak,

Is there an automatic filter for top 3 as I need to have top 3 done automatically. If there is a way to do this in the filter portion could you screenshot as I cannot find it.

Thanks again,

Hamza

• ###### 8. Re: finding max 3

Actually nvmd I got it!

Thanks Deepak!!