my dataset has two day camps and quantity.
in the report wanted to calculate the amount per day, for that I need to say the words I want eg day 2
My dataset returns the information in this way.
day Quantity
1 5
1 2
1 4
2 5
...
1 8
tentei usar esta expresão mas nao resultou
=Sum(Fields!Qntshoes.Value) and Fields!Day.Value = 1