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?
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.
Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button! | Follow me on Linkedin
