If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Is it possible to...?

Started by JennyO, 14 Nov 2012 02:36:25 PM

Previous topic - Next topic

JennyO

Is it possible to have a list report generated to show information from the same model in multiple columns?

For example, one of my model items I selected is Income Type. I would like to be able to show Hours, as well as Tips, from the income type on the same line, as opposed to seperate lines, for each employee. Is that something that can be done, and if so, how? I have the amount set up so that it has somewhere to display it, so I'll need that twice as well. I've set up a filter on the Income Type (original) to display only the Tips, but unless I want the hours on a second line (by just adding the additional Hours column and the RG1 to my filter) I don't know what to do.

If I can't make it all on one line, how do I supress the zeros in the columns? I would prefer that the 0 in the Hours column not be displayed on the row for tips, only for RG1. I would also prefer that an amount not be displayed for the hours.

Ideally what I would like my report list to look like is this:
Employee ID     Full Name     Income Type     Amount     Income Type     Hours
4275                Joe Smith    Tips                  243.75     Regular             30

And if I'm not being clear enough on what I want, please ask and additional questions. :)

navissar

If I understand you correctly, you want to aggregate different values of the same field together. You can use a calculated field with:
case when [income_type]='Tips' OR [income_type]='Hours' then 'Tips&Hours'
else [income_type] end
This field will return "Tips&Hours" whenever the income type is either hours or tips, and the income type in any other case.
Your measure would simply aggregate to that field's level.


Bark

Why not a corsstab?

Regards,

Bark

JennyO

Quote from: Bark on 15 Nov 2012 05:15:44 AM
Why not a corsstab?

Regards,

Bark

That's certainly a possibility, but I know nothing about crosstabs. I'm self taught, and most things we work with are lists of data.

If perhaps you could give me info on how to do such?