I am trying to produce a report similar to the image below. Showing
the item/size/descr, cost, total pledged and total dollars pledged.
The source data includes the following columns. Columns E-K are
repeated 10 times indicating the transaction could have up to 10 items
included.
If it were a single item per transaction, easy. But, how do i
accumulate the total per SKU when it spans multiple columns per
transaction.
My challenge is how to sum the #Pledged for a given Prem/Size (Description) when the Prem/Size is found in multiple columns.
The alignment of results ==> source data:
Prem ==> Column K and Column R
Size ==> Column F and Column M
Description ==> Column E and Column L
Cost ==> Column G and Column N
#Pledged ==> Column I and Column P
$Pledged ==> Column B
Premium Sent ==> ignore
IP Logged
