Print Page | Close Window

Add a column to crosstab

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=17451
Printed Date: 06 May 2024 at 8:46am


Topic: Add a column to crosstab
Posted By: totoune
Subject: Add a column to crosstab
Date Posted: 29 Aug 2012 at 12:38pm
Dear experts,

i am using crystal 2008. i have a crosstab that display the following

Item Group          Item          Total
A                   A1             10000
                    A2             5000
                    A3             1000
------------------------------------------
Total                             16000

i need to add a seperate column near item which is the measurment for the item like KG, M

A                   A1          Kg          10000
                    A2           m           5000

is it possible i crosstab?



Replies:
Posted By: hilfy
Date Posted: 30 Aug 2012 at 4:07am
Add the field that has the measurement type for the item to the Summarized Fields in your cross-tab.  Set the summary to either Maximum or Minimum.  This assumes that there is only one possible measurement type value for each row in the cross-tab.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics



Print Page | Close Window