range setting in Flow field

ebrahma

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

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.

regards

Savatage

Did you ever think about setting up customer & item dimensions?

ebrahma

Hi,

We have only two Global diemensions and that too used for other purposes. Our client didn't purchase advance dimensions.


regards

Savatage

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.

in sales reports you want to do something like the Customer/Item Statistics Report?

Alterant

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!