Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
where statement in Impromptu
John We have already filtered the data for the periods required using the IN command in the Filter for Periods 31,32,33 and 34. We now want to create columns for each Period without having to create a cross-tab report. When Period = 31 the Sum all Sales data for Account Code in Period 31 and...- srf
- Post #3
- Forum: Cognos solutions
-
where statement in Impromptu
We are extracting sales information for a number of periods and wish to create a columnar report for the sales codes WHERE the periods = specific values. We are using a grouped list format for this report as a cross-tab does not suit our needs. Does a WHERE statement exist in Cognos or can we...- srf
- Thread
- Replies: 4
- Forum: Cognos solutions
-
Developing Profit and Loss Account in Impromptu
As a new user to Impromptu I am struggling to develop a Profit and Loss Account in Impromptu. The format is as follows : Mth 1 Mth 2 Mth 3 Mth 4 Sales Int Sales 10 Ext Sales 20 Other Sales 20 Total Sales 50 The problem is that a...- srf
- Thread
- Replies: 1
- Forum: Cognos solutions
