Right what am doing is trying to analysis sales from my companies website and we are running different marketing campaigns for different product groups.
What am wanting to do is show all the rows of an invoice where the customer has purchased some thing from the selected product group.
For example if i select boardies from my list box i want to see all invoices and row where boardies has been one of the item purchased.
Is there a way of doing this any advise would be great.
Should be possible by using set analysis to create a selection of the possible invoices (using the p() function), and clearing the seleted items in the set.
Maybe something like this (assume you've selected in field item):
Create a straight table with customer, invoice, row and as expression
Should be possible by using set analysis to create a selection of the possible invoices (using the p() function), and clearing the seleted items in the set.
Maybe something like this (assume you've selected in field item):
Create a straight table with customer, invoice, row and as expression
