Author Topic: How can I get my % values?  (Read 816 times)

Offline satiyabaazi

  • Full Member
  • ***
  • Join Date: Sep 2016
  • Posts: 9
  • Forum Citizenship: +0/-0
How can I get my % values?
« on: 07 Oct 2016 12:17:21 pm »
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.

 



           
Twittear