February 22, 2007, 05:53 PM
jcs1226Hide certain columns while using across function
Hi everyone,
I am using ACROSS MONTH to display counts of data BY three fields. I want to display only the current month (last column of across) along with the ROW TOTAL (FYTD - Fiscal Year to Date).
I don't think I can use where statements b/c my row total would not give FYTD.
Don't think I can use syling either? Thinking that the number of columns will vary depending on the month I run it. For example in February I would only want to display the second column in across, in March only the thrid column in across, etc.
Does anyone have suggestions. Thanks in advance!
February 22, 2007, 10:23 PM
susannahjcs, have you read up on FML? Financial Modelling Language, a part of webfocus that is just exactly perfect for your request. Its not an extra product, its already part of the focus you have.
February 23, 2007, 10:55 AM
jcs1226Hi Susannah,
I didn't realize it was not an extra product! Thanks for the information. Is there a specific feature that you had in mind for solving. Thanks for the help!
February 23, 2007, 12:29 PM
Tony AJCS,
A little DEFINE and judicious coding and you can do it in a straight TABLE -
-DEFAULT &Month = 2
-DEFAULT &Year = 1996
DEFINE FILE GGSALES
FISCAL_YTD/D12.2C = DOLLARS;
YEAR/YY = DATE;
MONTH/M = DATE;
FISCAL_MTH/D12.2C = IF YEAR EQ &Year AND MONTH EQ &Month THEN DOLLARS ELSE 0;
END
TABLE FILE GGSALES
SUM FISCAL_MTH
FISCAL_YTD
WHERE YEAR EQ &Year
END
-RUN
T
February 24, 2007, 04:12 AM
OPALTOSHYou do not need ACROSS to do what you want to do.
Use a COMPUTE or DEFINE to calculate your FYTD columns and display them and thenuse a ROW-TOTAL.