on 10-12-2007 9:16 AM
Hi Gurus,
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...
Very Urgent...
Thanks in Advance..
Regards
Mano
Mano,
Are you saying that it is displaying correct rows but the total is for all values? If so, select your key figure and look into the Properties section. Change the 'Calculate Results As' to summation.
Regards
Gill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,do you have vehoicle number in rows? have this at first position in rows and create condition on Vehicle number.(you may hide this from display if you dont need)
Message was edited by:
Muralidhar C
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.