Avoiding Items which doesn't have Vendor Names

[kkkumar82]

Hi All,

Please find below data

Vendor_Name	Item	Component
AFFYMETRIX INC	301110-01	301110-01
	301110-01	301110-01
AFFYMETRIX INC	301130B	301110-01
BERLIN PACKAGING LLC.	301130B	301110-01
Charter Medical	301130B	301110-01
	301130B	301110-01
	105585	301110-01
	301110	301110-01

In fact I was writing a condition like if(isnull(Vendor_Name), Item) but came to know that for eg 301130B

it should not show up as 301130B has other vendors.

The only output I should get is

105585, 301110 as they are not part of another Vendor

Attaching excel of the same

[kkkumar82]

For now I cannot sunny I think I have to cook some data based on my model

Just one question

if the requirement is on component rather than Item but Item being the first dimension in the chart, is it necessary

I write my set analysis saying Item = {} or can I also write with Component ={}

Hope Iam clear

[kkkumar82]

sunny can you give me stephan example of using e() in an expression, I missing something when I am trying

[swuehl]

Kiran kumar Cherukupally wrote:

Sunny's suggestion

{<Item = {"=Len(Trim(Concat(DISTINCT Vendor_Name))) = 0"}>}

Yours

{<Item = {"=Len(Trim(Concat({<Item = e({<Vendor_Name = {"*"} >} ) >} DISTINCT Item,', '))) = 0"}>}

is this what your are suggesting Stefan

no, that's not what I suggested.

Your sample  data does not show a component of interest, right?

I've change a line, and then I've adapted the expression to filter component:

Item	Component	Sum({<Component = e({<Vendor_Name = {"*"}>}) >} 1)
		1
301130B	301110-02	1