Calculate amount of last invoice of each customer before a selected month
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