Focal Point
[SOLVED] Bar Graph - Modifying x-axis labels

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/989102512

August 20, 2009, 09:57 AM
arsalan
[SOLVED] Bar Graph - Modifying x-axis labels
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.