Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Sum{<Year=,Month=>} Sales)
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)
Hi Rutali, maybe?
Sum({1<YearField=P(YearField), Monthfield=P(Monthfield)>} Sales)