Use values from Table visual

[Anonymous]

Hi All , 

I have visual table in my report  which consist of many measures from diferent tables . Thease measures i hvae displayed using  Traffic light colors . Now i have to use this data to show summray .

Example :

                  London       Essex       Liverpool       Machestar

Site A           Red         Green         Green            Amber

Site B           Red          Red            Green            Red

From the above  i need to show how many green , red and amber are there in whole sleection.Please help.

Regards

Salma

[lbendlin]

Use HASONEVALUE() to figure out if your context is a single cell, a row or column total, or a grand total.  Then create the measure you want for the grand total.  How are you planning to display the result?  Via CONCATENATEX() ?