Column F (pivot calculation) of "Sum of Calculated Rebate" is wrong. The calculation is "Sum of Rebate per unit divided by "Invoice Date WAC". I am not sure what I need to do to correct them. The manual calculation is in column i is correct. Please help to correct the pivot column F to match column i. Pivot is attached in this post. please help.
Thank you,
Mercy
Mercy
Hi Mercy26,
look at "wher is problem.xlsx"Column F (pivot calculation) of "Sum of Calculated Rebate" is wrong.
I personally don't know how to get "Max" into the appropriate formula,Please help to correct the pivot column F to match column i.
but I have a (perhaps non-standard) solution - look at "pivot sample inquiry v1.xlsx".
I added 2 columns to the "Data" tab, and used them to insert
the desired Max value into the formula. If it's not clear to you, write.
ms
Having 365, I'd use the data model, as in the attached.
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks