sum question

[jadams123]

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 )

Thanks,

[sunny_talwar]

May be try this:

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

[jadams123]

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