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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
how to calculate the total % in cross tab?
Hi! If you are using a table as a datasource (it's different with cubes as a datasource) in your crosstab, insert a query calculation beneath your primary column. Your formula should look like this: percentage(measure) hth- krrogovin
- Post #2
- Forum: Cognos solutions
-
Cognos8 and Dimensional Data Reporting for Percentage formulas
Hi JGirl, Unfortunately, this didn't work either. I received the following error: Unable to support query items from the same dimension on different report dimensions 'edge=axis(0); dimension=[MEASURES]''edge=axis(2); dimension=[MEASURES]'. I think I have to show the intersection between the...- krrogovin
- Post #3
- Forum: Cognos solutions
-
Cognos8 and Dimensional Data Reporting for Percentage formulas
Hi, I am trying to create a percentage formula in a Cognos8 Reportnet crosstab report using dimensional data. The reports looks as follows: Time (All members--so this is dynamic) Product(decendants) Qty %ofTotal 2006 Product A 100 10%...- krrogovin
- Thread
- Replies: 2
- Forum: Cognos solutions
