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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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