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

Counting conditionally formatted columns

Started by m23, 31 Mar 2010 01:45:10 AM

Previous topic - Next topic

m23

Hi,
I have a report that uses conditional formatting to highlight each cell in a list 1 of 3 colours depending on the data in another column. ie

col1data is displayed col1col is used to set the colour.

Does any one know if there is an easy way at the end of this list to display a count of the number of times each different colour is used ie

                         col1       col2        col3



--------------------------------------------
Colour1 total:        5           7            6
Colour2 total:        2           0            1
Colour3 total:        3           3            3
--------------------------------------------