Only Red Color Values sum - Table Box

[Ramu]

Hi Frank,

Sorry for the trouble , This requirement is Qliksense .I attached the test data .

My Requirement is Current block and previous block information is there.

I have taken one table box and it's , I took Previous block as Dimension, Remaining things consider as a Measures  just like

Count({$<Month_Year= {$(=MAXSTRING(Month_Year))},Current block={'A'}>}Match(Current block,Previous block))/
Count({$<Month_Year= {$(=MAXSTRING(Month_Year))}>}Match(Current block,Previous block))   ---For A of Current Block

Vise versa B ,C ,D, E  also same .in the table box measure i taken   individually ---(I took 5 measures  ---1 for A, 2 for B ,3 for C like)

In Qliksense table box :-

Based on the condition I have given color codes. Count Values <=5 is Blue color and Count Values >=5

 is red color,If Current and Previous is Equal it shows Green. 

My Requirement is: I want to display the sum of the all red color values, Every column and every row wise .Please can you help me.

Thanks,

Ram