November 30, 2007, 03:17 PM
<GGOFAnalyst>Layout
I'm trying to make my report look a certain way and I was wondering what would be the best method to get the output to look like the way shown below.
Dec 07 Jan 08 Feb 08 FYD Total
Total|Budget Total|Budget Total|Budget Total|Budget|Variance
Province 1
Province 2
Province 3
Total
November 30, 2007, 04:28 PM
GinnyJakesYou are going to have to give us more information. What part of what you specified are column headings? Or is every line a different set of totals?
Please give us a little more to work with from the data input side.
Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
November 30, 2007, 04:40 PM
<GGOFAnalyst>Yea I guess it changes the format on here when you paste.
The Dates are the column headings and the Total|Budget are column subheadings. The provinces are the row headings.
Does that help?
November 30, 2007, 04:48 PM
GinnyJakesAre you going to have a set of column subheadings for each date heading?
Tell us about your measures, i.e. the data that you are adding up to put in the buckets.
Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
November 30, 2007, 04:52 PM
<GGOFAnalyst>Right now I'm including the dates as my column headings. I haven't separated them into headings and subheadings yet.
There's already a Total field and the budget is a set number and my variance is total - budget.
November 30, 2007, 04:59 PM
GinnyJakesWell, here is some quick pseudo-code that might work though I don't totally understand:
TABLE FILE filename
SUM TOTAL BUDGET
COMPUTE VARIANCE/D12.2=BUDGET-TOTAL;
BY PROVINCE
ACROSS DATES ROW-TOTAL
END
Does that make sense to you based on your data?
Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
December 03, 2007, 11:57 AM
<GGOFAnalyst>Yes that's what I was looking for.
Thank you
December 03, 2007, 12:28 PM
<GGOFAnalyst>Right now it shows EXPDATE_MMYY as the column heading and then underneath it it's Nov, 2007. I was wondering how can I get rid of the column heading EXPDATE_MMYY. I just want it to show the date as Nov, 2007.
This is my code:
TABLE FILE EXPENSES
SUM
TOTALAMOUNT/D15.2 AS 'Total'
MAX.BUDGET AS 'Budget'
MAX.VARIANCE AS 'Variance'
BY REGION AS 'Region'
ACROSS EXPDATE_MMYY ROW-TOTAL; AS 'Total'
WHERE EXPENSEDATE GE '20071101';
WHERE REGION NE ' ';
END
December 03, 2007, 12:53 PM
GinnyJakesTake the semicolon off of the ACROSS and say AS '' which gives you no title.
TABLE FILE EXPENSES
SUM
TOTALAMOUNT/D15.2 AS 'Total'
MAX.BUDGET AS 'Budget'
MAX.VARIANCE AS 'Variance'
BY REGION AS 'Region'
ACROSS EXPDATE_MMYY ROW-TOTAL AS ''
WHERE EXPENSEDATE GE '20071101';
WHERE REGION NE ' ';
END
Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
December 03, 2007, 01:43 PM
<GGOFAnalyst>That doesn't get rid of it. That just changes the name of the Total.
December 03, 2007, 02:38 PM
<GGOFAnalyst>I figured it out.