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. :)
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.
Why not a corsstab?
Regards,
Bark
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?