how to get customers have sales more than threshold amount

[Charam]

I have a table called sales. It has customer column and their sales(Non summarized) in different column.  A customer can have more than one transaction. Here my problem is to create a new column with customer names where their sales more than 100000. I know there's going to be blanks in the new column because we need to get only customers have sales more than 100000 and the rest of the customer willl go into blank . i'm going to use this to some other analysis, thats why i need it as a separate column.

Any Thoughts...!!

[Ashish_Mathur]

Hi,

Share the data and show the expected result.

[Charam]

Here we go.... I dont know this could be possible or not...

[Ashish_Mathur]

Hi,

So you want to show the Customer Name in a new column only when the cumulative sales for that CUstomer are > 1500 and it is the last date for that Customer.  Am i correct?

[Charam]

Its not date dependant, i just want to show the customer name in new column where cumulative sales greater than $1500 regardless of what date it is.

Thank you..

[Ashish_Mathur]

Hi,

Try this calculated column formula

=IF(CALCULATE(SUM(Data[sales]),FILTER(Data,Data[Customer]=EARLIER(Data[Customer])))>1500,Data[Customer],BLANK())

Hope this helps.