How to write calculation to fetch 1 month, 3month, 6month,9month and 12 month sales

[Hariprasad]

Hi Team,

I want to know how to get 1 month, 3month, 6month,9month and 12 month sales, help me how to write calculation to data

	1		= count(claims) for vehicle with time in service <=1 * 100  / count(vehicle with time in service <=1)
	3		= count(claims) for vehicle with time in service <=3 * 100 / count(vehicle with time in service <=3)
	6		= count(claims) for vehicle with time in service <=6 * 100 / count(vehicle with time in service <=6)
	9		= count(claims) for vehicle with time in service <=9 * 100 / count(vehicle with time in service <=9)
	12		= count(claims) for vehicle with time in service <=12 * 100  / count(vehicle with time in service <=12)

[ogster1974]

assuming you have fields already created as you describe have you tried

for vehicle with time in service <=1 etc...

count({<[time in service]={"<=1"}>}claims)

count({<[time in service]={"<=3"}>}claims)

count({<[time in service]={"<=6"}>}claims)

count({<[time in service]={"<=9"}>}claims)

count({<[time in service]={"<=12"}>}claims)

into your calculations?