Skip to main content
B
bwilson-21-Visitor
1-Visitor
June 15, 2011
Question

QB report

  • June 15, 2011
  • 1 reply
  • 600 views

Hi all,


What I am looking doesn't sound too difficult but I can't figure it out. Any help would be appreciated.


I want to create a report that I can use in Cognos. I have a report that shows the states of a variance with its associated count. It returns each state and the number of variances in that state. Now I need to add one more variable. I need to be able to differentiate between deviaitons and waivers. I would like a table chart that has state along the x axis, type along the y axis and count as the measure. I have the state and the count I just can't figure out how to add the type as a third variable. Any thoughts would be great!


Brian

1 reply

A
AL_ANDERSON12-Amethyst
12-Amethyst
June 18, 2011
Use Type (Display Type) in your output along with State. It should show
whether each variance is a Waiver or a Deviation.

Al Anderson





Brian Wilson <briwilson@coca-cola.com>
06/15/2011 01:39 PM
Please respond to
Brian Wilson <briwilson@coca-cola.com>


To
-
cc

Subject
[solutions] - QB report




Caterpillar: Confidential Green Retain Until: 07/15/2011



Hi all,
What I am looking doesn't sound too difficult but I can't figure it out.
Any help would be appreciated.
I want to create a report that I can use in Cognos. I have a report that
shows the states of a variance with its associated count. It returns each
state and the number of variances in that state. Now I need to add one
more variable. I need to be able to differentiate between deviaitons and
waivers. I would like a table chart that has state along the x axis, type
along the y axis and count as the measure. I have the state and the count
I just can't figure out how to add the type as a third variable. Any
thoughts would be great!
Brian

Site Links: View post online View mailing list online Send new post
via email Unsubscribe from this mailing list Manage your subscription
Use of this email content is governed by the terms of service at:
Terms & ConditionsAccessibility statement