I've created a bar graph by using 2 BY fields to display bars in highest to lowest order. This code works fine but the problem is, on x-axis it shows the value of both BY fields combined together.
MATCH FILE ASUM PRINT QUANTITY BY YRQTR RUN FILE ASV PRINT GOAL BY YRQTR RUN FILE ANSUMVOL PRINT VOLUME PRODGRP PRODLINE PROD_NR BY YRQTR AFTER MATCH HOLD OLD-AND-NEW END
TABLE FILE HOLD SUM PRODGRP PRODLINE YRQTR COMPUTE QUAN_VOL/D12.2 = QUANTITY / VOLUME; GOAL BY '&BYDSPLY' END
GRAPH FILE HOLD SUM QUAN_VOL GOAL BY HIGHEST QUAN_VOL AS '' BY '&BYDSPLY' END
Is there a way to show the value of '&BYDSPLY' only and not QUAN_VOL. '&BYDSPLY' is a variable that can have different x-axis values.
Thanks.This message has been edited. Last edited by: Kerry,
September 04, 2009, 10:45 AM
Kerry
Hi Arsalan,
Has this issue been resolved? You might want to try NOPRINT for this one.
Cheers,
Kerry
Kerry Zhan Focal Point Moderator Information Builders, Inc.
September 04, 2009, 12:57 PM
arsalan
Yes, it's resolved. I tried NOPRINT with some other combination of code. Thanks.