Keeping a value constant

[prabhu_rutali]

Im having a data in which I have sales and quantity.If I divide sales upon quantity , I get a value which  changes month year wise. How can I keep this value constanti.e on selection of month year and it must not change with other fields

[its_anandrjs]

Try this

Sum{<Year=,Month=>} Sales)

[its_anandrjs]

If you need on other fields also not change sales value then try to add that also

Sum({<Year=,Month=>} Sales)

Or

By this all fields no selection affect

Sum( {1} Sales)

[rubenmarin]

Hi Rutali, maybe?

Sum({1<YearField=P(YearField), Monthfield=P(Monthfield)>} Sales)