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.