[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3351
  • Last Modified:

How to remove duplicate line item from report?

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!
0
jdol2949
Asked:
jdol2949
1 Solution
 
peter57rCommented:
If you know what the specific record is, can't you exclude it via the record selection rules?
0
 
jdol2949Author Commented:
I dont think so.  If I exclude the item itself, it will remove it from the entire report.  I still need the item to show up under the "GroupABC", but I need to exclude it from the "GroupDEF.
0
 
jdol2949Author Commented:
If there is a way to exclude via record selection rules, to meet my criteria, it do not have that knowledge.
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
peter57rCommented:
No record can appear in two groups.
If what you are seeing is the 'same' record in 2 groups then there are 2 records.
If you can specify logic to suppress one of them then you must be able to use the same logic to exclude that record in the first place.
0
 
mlmccCommented:
Agree.  There must be 2 records and something in them is different since it is putting them in 2 different groups.

WHat is the group1 criteria?  You could use the select expert to filter that record.

A better idea would be to find it in the database and delete it.

mlmcc
0
 
James0628Commented:
 You said that Group1 was ItemClass, in which case you should be able to exclude that record using a record selection formula like:

Not ({table.ItemClass} = "DEF" and {table.Item} = "ABC")


 Obviously, replace "table" with your datasource name.

 James
0
 
jdol2949Author Commented:
Thanks peter57r.  You are correct.  I was chasing a simple nuts and bolts problem, but looking at it wrong.  Your feedback got me to slow down and look harder.  Thanks!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now