range setting in Flow field

ebrahma wrote:

Supposedly For an example, Customer and item code is the key for the flow filed quantity.

You mean SumIndexField?

ebrahma wrote:

I could able to filter customer and item inorder to know the quantity of the particular item purchased by a single customer.

Can i apply range to customers and items which are part of flow field keys.

ultimate is i need to know how much the single item purchased by many customers and many items purchased by single customer usning the above scenario.

If so, what's the problem?

Have a table with fields:
Cust No.
Item No.
Quantity

and keys:
Cust No., Item No. - SumIndexField = Quantity.

In any other table (Customer for example), you can make FlowFilter field "Item Filter", and FlowField "Total Quantity" linked with SumIndexField Quantity like this:
Method = "Sum"
Table = ...
Field = "Quantity"
Table Filter = "Cust No.=FIELD(No.), Item No.=FIELD(Item Filter)"

In than case, when you open customer table you'll have total quantity for that customer for all items in field "Total Quantity". When you set Flow Filter, you will have total quantity for particular items, which are in filter.


Althow, you can create dummy table with one record and two Flow Filters.
So you can get information about quantity of paticular items sold to particular customers.

P.S. Use Item Filter carefully, different Items may have different Units of Mesure.

Good Luck!