Hello all.
I have created a report that is giving me more information than i need. I used the select expert to try and limit the information, but then I lose half of my information that i'm looking for.
Here's the situation:
I'm trying to see what our customers' entire buying history are that have purchased a product that is considered CLASS "m"
for example:
Customer "x" orders on 3 different Occasions
Order # "1"
purcahses items from CLASS "m", "n",
Order # "2"
purcahses items from CLASS "x", "y"
Order # "3"
purcahses items from CLASS "z"
Because one of his orders includes CLASS "m" product, I need the information for all 3 Orders.
Also, If a customers' Buying history doesn't include CLASS "m", then i don't want it to display on my report.
I have tried using the select expert on the CLASS field.
{table.CLASS}="m"
This only gives me all the CLASS "m" products that the customer has purchased.
Any suggestions would be greatly appreciated. Thank you in advance for your help.
ktatpe
I have created a report that is giving me more information than i need. I used the select expert to try and limit the information, but then I lose half of my information that i'm looking for.
Here's the situation:
I'm trying to see what our customers' entire buying history are that have purchased a product that is considered CLASS "m"
for example:
Customer "x" orders on 3 different Occasions
Order # "1"
purcahses items from CLASS "m", "n",
Order # "2"
purcahses items from CLASS "x", "y"
Order # "3"
purcahses items from CLASS "z"
Because one of his orders includes CLASS "m" product, I need the information for all 3 Orders.
Also, If a customers' Buying history doesn't include CLASS "m", then i don't want it to display on my report.
I have tried using the select expert on the CLASS field.
{table.CLASS}="m"
This only gives me all the CLASS "m" products that the customer has purchased.
Any suggestions would be greatly appreciated. Thank you in advance for your help.
ktatpe