6 Replies Latest reply on Feb 23, 2016 1:34 PM by Shawn Wallwork

# Calculating Max of date for each customer with the amount associated with same date.

Hi Everyone,

Below is how my data Looks,

My question is, I wanted to see all customers, With Max of the date and Amount associated with max of date.

ex:      Glass LLC         11/30/15         5075       ( can see in above pic)

fitness LLC         2/19/13             0

And the Balance column is a Dimension field for me.

Thanks,

• ###### 1. Re: Calculating Max of date for each customer with the amount associated with same date.

Try:

IF   {FIXED [Customer] : MAX([Date]) } = [Date] THEN [My Measure] END

Aggregate it when you drag it into the view.

--Shawn

• ###### 2. Re: Calculating Max of date for each customer with the amount associated with same date.

Amount field i am using is a Dimension.

and below is how i got applying the above formula.

• ###### 3. Re: Calculating Max of date for each customer with the amount associated with same date.

What do you mean by aggregate it while pulling into View?

• ###### 4. Re: Calculating Max of date for each customer with the amount associated with same date.

OK, please give me a screenshot of the pills that are on the rows and columns shelves. And a brief description of what the pills are (# dimension, string dimension, etc.) Thx.

--Shawn

• ###### 5. Re: Calculating Max of date for each customer with the amount associated with same date.

Sorry for the trouble... I placed the pill in measures so wasn't correct.

I found it, your formula worked for me now. Have to see how it will work when i add more fields onto the sheets.