How to accumulate the total per SKU
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22479
Printed Date: 01 May 2024 at 6:51pm
Topic: How to accumulate the total per SKU
Posted By: DonaldX
Subject: How to accumulate the total per SKU
Date Posted: 17 Oct 2017 at 10:35am
|
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 ------------- DX |
Replies:
Posted By: hilfy
Date Posted: 23 Oct 2017 at 7:57am
|
Are you connecting Crystal to a spreadsheet or is the data in a database?
-Dell ------------- Proviti, Data & Analytics Practice http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics |