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

How can I get my % values?

Started by satiyabaazi, 07 Oct 2016 12:17:21 PM

Previous topic - Next topic

satiyabaazi

I want to show my top 10 contributors in a dashboard with the number of votes and the percentage. I used to do it easily in report studio using

total(numberOfVotes)/ total(total(numberOfVotes) for report)


But now with Cognos 11.0.4, can I please get some help to show a grid like the one below:

Contributor| # of Votes| % of total Votes
x1|10|1%
x2|20|2%

considering total number of Votes = 1000.

Thanks for the help guys. Highly appreciated.