In my QVW one of the fields named sales has a value which is correct for each week if i take it in a text box, if i use a text object and do SUM(Sales) what happens is instead of calculating the sales for the given filters its calculating the sales for everything because the sales is already aggregated before coming into this QVW.
If i pick a certain date and in the text object if i do Sales i get the exact value but if i do sum(sales) it gives me everything.
The problem with this is, if i pick multiple dates the text box gets blanked out as i am not doing any aggregation operation.
But how does that change? In the set analysis i am saying for tran channel POS and Tran Type ID 1 give me the Tran count and we used the same filters right?
Also, can you please use just
=Sum([Transaction Count])
in the blue box and see what values do we get we dont get the desired value
