Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 18, 2017 at 07:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 17, 2017 at 01:16 PM

    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

    Add comment
    10|10000 characters needed 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