P() and E()

[fkeuroglian]

Hi Expert 

I want to create a report that said me if one DOCUMENT buy other product in the last 12 months, for example in this case the report have to return only 12345 a 10/2/2016 because in this actual month(08 august) the same document but other product in the last 12 months(10/02/2016 mont=february)

Document	Product	Date
12345	a	10/2/2016
12345	b	10/8/2016
455	a	10/8/2016
887	c	10/2/2016

I have to use P() and E() FUNCTIONS?

somebody have an example to applicate to this case?

Thanks a lot

ATTACHED THIS SAME EXCEL

[pablolabbe]

Hi Fernando,

  Can you post an example of the final result that you need ?

Pablo

[pablolabbe]

A short explanation about each function

P() let you define an element set based on possible values for a field implied by selections defined inside the parenthesis.

Example:

sum( {$<Customer = P({1<Product={‘Shoe’}>} Customer)>} Sales )
returns the sales for current selection, but only those customers that ever have bought the product ‘Shoe’. The element function P( ) here returns a list of possible customers; those that are implied by the selection ‘Shoe’ in the field Product.

E() let you define an element set based on excluded values of a field implied by selections defined inside the parenthesis.

Example:

sum( {$<Customer = E({1<Product={‘Shoe’}>})>} Sales )
returns the sales for current selection, but only those customers that never bought the product ‘Shoe’. The element function E( ) here returns the list of excluded customers; those that are excluded by the selection ‘Shoe’ in the field Product.

[fkeuroglian]

Pablo, this will be the result

12345 a 10/2/2016

because at this month(august) buy another product(b) and as the line show, he bought some other product(a) in the last 12 months

thanks