Skip to Content
0

How to accumulate the total per SKU when the SKU is in multiple columns per transaction.

Oct 17, 2017 at 12:30 PM

30

avatar image
Former Member

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.

results.jpg (93.8 kB)
sourcedata.jpg (266.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member Oct 17, 2017 at 09:59 PM
0

Hi Donald,

You can create a group on Prem column and then make use sum function on all measures that u want to sum.

Thanks,

Anish

Share
10 |10000 characters needed characters left characters exceeded
Ian Waterman Oct 18, 2017 at 07:58 AM
0

You will have to explain your logic.

Take us through a complicated example, use one product from your source data and explain how results will be defined.

That is show all the source data for one product and detail how its should be summarized into one result record.

Ian

Share
10 |10000 characters needed characters left characters exceeded
Ian Waterman Oct 17, 2017 at 01:16 PM
0

Create a formula which adds required columns together.

The Source data and results data you show do not appear to be related.

If creating a formula does not solve your problem you will need to give more info detailing how source is converted to results.

Ian

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0