Count amount of duplications - with conditions

[yanivbm88]

Hello All,

I am trying to find amount of duplications within a database, based on certain columns with conditions.

Below is a sample of the data I have:

• ID, VednorCode, ItemName is the raw data.
• Duplications is what I am trying to get (In Yellow)

ID	VendorCode	ItemName	Duplications
1	H90042800	6251	2
2	H90042800	6357	-
3	H90042800	6251	2
4	H90042800	PD-6251-300	2
5	H90042800	PD-6251-300	2
6	H90042800	PD-6252-300	1
7	H03000785	PD-6252-300	-
8	H03000785	PD-6011-300	-
9	H03000773	PD-6011-300	1
10	H03000773	6357	-

Duplications column should follow the below guidelines:

• Show the total amount of times each combination of VednorCode and ItemName appears.
  • Amount in each line refers to VendorCode and ItemName in the same line.

• Columns where one of the following happens should not be counted:
  • ItemName is '6357'
  • VendorCode is 'H03000785'.

I am already familiar with Count(TOTAL <VendorCode, ItemName> ID) as a solution, but I want to add conditions to it.

Any ideas?

[vinieme12 · Accepted solution]

Try below

Count({<ID = e({<ItemName ={6357}>+<VendorCode={'H03000785'}>} ID) >} TOTAL <VendorCode, ItemName>   ID)