Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     About Table / Record question?
Go
New
Search
Notify
Tools
Reply
  
About Table / Record question?
 Login/Join
 
Gold member
posted
There are only those records in the table like this:

Year Month Value
-------------------------
2003 Jan 12345
2003 Feb 34534
2003 Mar 32324
2003 Apr 34522
2003 May 34554


My question is: How can I show the others Month in the report (eg. Jun, Jul, Aug, Sep, Oct, Nov & Dec)
 
Posts: 55 | Registered: May 15, 2004Reply With QuoteReport This Post
<pranasH>
posted
1. Create file with all mounths listed e.g. small FOCUS file
2. Use MERGE ... MATCH ... OLD-OR-NEW (check doc. for MERGE OLD-OR-NEW)

Pranas
 
Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Or using FML (Financial Modeling Language):

TABLE FILE CAR
SUM SALES
FOR COUNTRY
'ENGLAND' OVER
'POLAND' OVER
'PORTUGAL' OVER
'SPAIN' OVER
'USA' OVER
'W GERMANY'
END

TABLE FILE
SUM VALUE
FOR MONTH
'Jan' OVER
'Feb' OVER
...
'Dec'
END

Regards,
Mikel

This message has been edited. Last edited by: <Mabel>,
 
Posts: 173 | Location: Madrid, Spain | Registered: May 09, 2003Reply With QuoteReport This Post
Expert
posted Hide Post
Ringo, this is a classic use of the McGyver (or MacGyver) technique. its documented and written about. Do a search on the word in Knowledge Base (use both spellings Wink ) and then look up the article on it in TABLE FILE CAR. Its too long to explain here, but you'll figure it out, and its very famous part of focus lore, ibi should give out tshirts!
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
Gold member
posted Hide Post
Thanks, Mikel, it works, But can I put the Month at the ACROSS field.




TABLE FILE
SUM VALUE OVER
DISCOUNT
BY YEAR
ACROSS MONTH
FOR MONTH
'Jan' OVER
'Feb' OVER
...
'Dec'END

Please help me!

This message has been edited. Last edited by: <Mabel>,
 
Posts: 55 | Registered: May 15, 2004Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Yes. Yesterday I forgot to mention the use of ROWS and COLUMNS in order to define your own sort sequence:


-* Columns sort sequence.
TABLE FILE CAR
SUM SALES
BY CAR
ACROSS COUNTRY
COLUMNS
'ENGLAND' AND
'POLAND' AND
'PORTUGAL' AND
'SPAIN' AND
'USA' AND
'W GERMANY'
END
-RUN

-* Rows sort sequence.
TABLE FILE CAR
SUM SALES
BY CAR
BY COUNTRY
ROWS
'ENGLAND' OVER
'POLAND' OVER
'PORTUGAL' OVER
'SPAIN' OVER
'USA' OVER
'W GERMANY'
END
-RUN

egards,
Mikel

This message has been edited. Last edited by: <Mabel>,
 
Posts: 173 | Location: Madrid, Spain | Registered: May 09, 2003Reply With QuoteReport This Post
Gold member
posted Hide Post
Thank you very much, Mikel, it works fine now!
 
Posts: 55 | Registered: May 15, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     About Table / Record question?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.