Problem faced in condition definition in Query output
I have a scenario where i have flat file input with Regcode, Weekno, Vehicleno as characteristics. Mileage, idletime as Keyfigures. I have created a report where i need to display the regcode as rows and mileage, idletime as columns.
But the condition is that value of mileage should be between 0 and 7999 of the each vehicles for the seperate weeks. I have specified this under condition by selecting the characteristics vehicle no and weekno.and mileage between 0 to 7999.
But the problem i am facing is the report gives the summed values of all the vehicles which does not fall between 0 and 7999.
How to go about ...Guide me...
Thanks in Advance..