In % of total Business-Count the customers?

[#1]

Dear Community.

I want to count the customers based on the slider % of the business .

i have attached the qvw file and explained the scenario in that file.

so please somebody can help me to solve the issue.

Thanks,

mukram.

[Anonymous]

There is a macro command called paretoSelect which used to be used before the DimensionLimits properties on a chart were introduced. You can probably calculate using that, triggered from a change in the variable behind your slider.

This is the detail from the API guide about this command:

Class	MemberType	Member	ParameterNo	Parameter	Type	Direction	Comment
Field	Method	ParetoSelect	return value	-			No return value
			1	Expression	String	in	Expression by which to sort the field values
			2	Percentage	Double	in, optional	Percentage of field values that should be selected after sorting by Expression (default is 80)
			3	SelectComplement	Boolean	in, optional	True if complement values are to be selected

Jonathan

[#3]

Dear Mukram,

Please see the attachment.

Here's one way of doing it.

Regards,

-Khaled.