Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1196
  • Last Modified:

Cognos 8 report studio

It am trying to write a report using Cognos 8 report studio. I am trying to add a data item in the query section to show the total for two grouping at once, and am having a hard time to get the proper results.

For example I want total sales by region and the by sales person, I can have the report show this,but I am trying to get it in an actual data item so I can run other calculations off of it.

I am trying to use the total function and can get the total for one or the other but not both

Thank You
0
tjc1978
Asked:
tjc1978
1 Solution
 
SNeupaneCommented:
Use total with for clause.
For example, for sales by region:
Total ([Sales] for [Region])

For person:
Total ([Sales] for [Person])

This limits the total for the data item after the for clause.
0
 
tjc1978Author Commented:
Thank you for your response. I found the answer by trial and error. I was looking for two groupings in one. here is the formula

Total([Sales] for [Region], [Person])
0
 
mlmccCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now