We are formating a report to illustrate a summary of customer activity. The report is based on one customer (CustomerNumber). Within that, it illustrates the customer spending on each of our product lines. We use that as our Group (ItemClass). Further, we then illustrate the summary each item (ItemNumber) in that class for total purchase. So it looks like this;
Group1 - ItemClass (with summary of total spend amount $)
Group2 - Item (with summary of qty purchased and total spend amount $)
The problem is that I have a specific item (Group2) that is showing up under two seperate ItemClass groups (Group1). have traced it back to a database problem. Going forward it should be solved. However, reporting on historical data is the issue.
I am needing a way to exclude this item from the reporting data, under one specific group of the two it shows up under. Something along this line of logic;
if Group1 = "DEF" and Item = "ABC" then (do not show up!!!)
I can supress the item in various ways, but the $ value still totals in the group summary - which is what I am trying to avoid. The bottom line goal is to exclue the $ value from the summarey.
Any help would be greatly appreciated!