Hi gurus,
we have categorised our customers as x, y and z in customer classification.
We have some customers who fall under x category and y category and z category, no we want a report which shows their order values and invoiced values for a period of time. in mcta we are not able to add customer classification as selection field. in report we want customer classification to be shown so that we can change their categories according to their invoiced values.
if there is an option in standard report or if i have to write a query what tables are best to get information for a particular customer. please advise gurus and thanks in advance.
Cheers,
Nathan.