cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Reports - Cross tab with additional non sumarized fields?

0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

DellSC
Active Contributor
0 Kudos

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