Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

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

Please advise

I can walk on water when it freezes
10 Replies
ali_hijazi
Partner - Master II
Partner - Master II
Author

Any other suggestions?!

I can walk on water when it freezes