Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Like this?
Let me know!
your document doesn't open it gives the following error
I dont' not why.
Maybe this one?
Just as a confirmation, I was able to open both the qvws attached by elena888
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
You can create a variable with the expression of "Last" and then use in the set analysis of the Sum.
Something like this...
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