Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jadams123
Creator
Creator

sum question

so this is my pivot table. I have expanded "Customer Claim" Code Group.

my formula for Sales_CY (Invoice only) is:

Sum( {$<GLYEAR = {$(#=MAX(GLYEAR))}, TRX_TYPE = {'Invoice'}, CREDIT_CODE = {'Yes'}>} AMOUNT )

QV.PNG

Thanks,

3 Replies
sunny_talwar

May be try this:

Sum(TOTAL {$<GLYEAR = {$(#=MAX(GLYEAR))}, TRX_TYPE = {'Invoice'}, CREDIT_CODE = {'Yes'}>} AMOUNT)

jadams123
Creator
Creator
Author

perfect...it worked beautifully.

sunny_talwar

Awesome, if you got what you wanted, please close this thread by marking correct answer.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny