Hello, I have a problem with an expression in a case of my tablix The first expression : Count (SU_OBJET LIKE "HL *") I shall like making a second expression: Count (SU_OBJET LIKE "HL *" AND SU_NIVEAU = 21) Regrettably it doesn't work and gives me the results of the first expression. Thank you in advance for your answers!

Hi, Use Count (SU_OBJET LIKE "HL *" ) AND SU_NIVEAU = 21Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/

And for the total the expression is : Sum(Count(SU_OBJET LIKE "HL *") AND SU_NIVEAU = 21) ? Thanks !

Sum(Count(AAAA)) is not possible in reporting services !Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/

Are you sure ? When I make a right click, there is an action "to add a total" and the expression is good =Sum(Count(AAA))