BusinessObjects Board

CROSStabl Report "summation" issue ...

building reports desktopintelligence
#1 


Dear Team..
I have following issue with Cross tab report format..

I have sample data as shown below..

MAT_NAME	MAT_TYPE	MAT_NO	M_ABS_VOLUME
P-SSO	  TYPE1	  MT1  	2
P-SSO	  TYPE1	  MT2  	2
P-SSO	  TYPE1	  MT3 	2
P-SSO	  TYPE1	  MT4	        2
P-SSO	  TYPE2	  MT5 	4
P-SSO	  TYPE2	  MT6 	4
P-SSO	  TYPE2	  MT7 	4
P-SSO	  TYPE2	  MT8 	4

I dont wish to show the column MAT_NO in my final cross tab report..
My expected Cross TAB format is


Mat_name  Mat_type
P-SSO      Typ1      Type2    
            8           16          --> SUM(m_abs_volume) for Each mat_name 
 
BUT WHAT Bo is giving me as shown below...


Mat_name  Mat_type
P-SSO      Typ1      Type2    
            2           4              



Please assist me ..how can i get the format i want...

Regards
nic

nicolei (BOB member since 2011-07-28)

#2

hello,
one solution is to use aggregation about m_abs_volume.
see this topic about aggregation.

azertyh :madagascar: (BOB member since 2005-10-27)

#3

thanks…wonderful write up…i got wht i wanted…
many thanks :slight_smile:

nicolei (BOB member since 2011-07-28)