Calculate amount of last invoice of each customer before a selected month

[ali_hijazi]

Hello

Can someone tell me how the firstsorted value is used?

I have a pivot table with Customer as dimension

I want to display for each customer the max InvoiceNumber before this month as well as the calculate the sum of the amount of each of last invoice number

Please advise

[sunny_talwar]

Would you be able to share some raw data with the expected output to help you better? It will be pure guesswork without a sample as its difficult to understand what you are trying to get

[ali_hijazi]

check attached document

Actually I'm trying to find the value of the last invoice of each customer not served in the selected month

hope you can help me in this

I'm able to get  the customers not served and the maximum invoice before october 2016

but How I can get the value of the last invoice of each customer not served ; I'm not able to

please advise

[Anonymous]

Like this?

Let me know!

[ali_hijazi]

your document doesn't open it gives the following error

[Anonymous]

I dont' not why.

Maybe this one?

[sunny_talwar]

Just as a confirmation, I was able to open both the qvws attached by elena888‌

[ali_hijazi]

here you got the invoice number what I want is to calculate the sales amount where invoice number is the one you got

How can I get the invoice number in set analysis?

i.e. sum of valueusd where invoice is the last one for each customer I have

[Anonymous]

You can create a variable with the expression of "Last" and then use in the set analysis of the Sum.

Something like this...

[ali_hijazi]

No no

you created the variable with an equal sign at the beginning

and this will give the sum for one invoice number which is the max

what I want is to calculate the sum for the last invoice of each customer not one only last Invoice as in your suggestion