How to fetch value in all rows?

[sergio0592]

Hi all,

I have a straight chart. My first expression is a sum for sales : sum( { < Month={"<=$(=num(Month))"} >  }   Sales)

My second exp is the number of employees in january : =sum( {<Month ={"01"}>} Employee)

So i have value for employee in january (89) but obviously 0 for the other months. How can i get 89 for all rows?

See my attached .qvw sample.

Thanks

[Anil_Babu_Samineni · Accepted solution]

May be use this?

=sum(TOTAL {<Month ={"01"}>} Employee)