on 04-25-2018 2:56 PM
Hi guys, I've created a crystal report with a cross tab. This cross tab currently contains the following fields
Item Data, and Item Sales (the sales is summarized monthly showing 6 months of data.
So my top tabs are "Total" April, March, Feb etc....."
I want to add 3 additional fields to the cross tab before total.
On Hand / Commited / On Order
These 3 fields are not to be sumarized and only required to display one piece of information which will be extracted directly from the SAP B1 OITW Table.
Any help is appreciated.
Kind Regards
Andy
You basically have to summarize them. However, if there's only one value per group for each, you can use maximum() or minimum() to correctly show the value in the cross-tab.
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.