Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
May be try this:
Sum(TOTAL {$<GLYEAR = {$(#=MAX(GLYEAR))}, TRX_TYPE = {'Invoice'}, CREDIT_CODE = {'Yes'}>} AMOUNT)
perfect...it worked beautifully.
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