Problem with counting

[#1]

Hello Everyone,

i want make this count in pivot table:

=count(DISTINCT( if(ENTRYDATE=ORDERDATE,

  if( ID=FIRST_ID,

   if(DOC_TYPE<>14, if(SOURCE_IDX<>7, ITEM))))))

My problem is that for ID=FIRST_ID i don't want make the control by row but by the column.

So for example if the table is that

ITEM	ORDERDATE	ENTRYDATE	ID	FIRST_ID	DOC_TYPE	SOURCE_IDX
BOX1	20.03.2014	20.03.2014	4	4	1111	99
BOX3	20.03.2014	20.03.2014	5	4	1111	99
BOX1	20.03.2014	20.03.2014	4	4	1111	99
BOX1	20.03.2014	20.03.2014	4	4	1111	99

i want count 4 item for BOX1 because there are 4 FIRST_ID equal to ID of BOX1.

Can you Help me? PS: i don't know i fixed value for the ID because it changes for every ITEM

Thank you,

Alfonso

[anbu1984]

=Aggr(count(DISTINCT( if(ENTRYDATE=ORDERDATE,

  if( ID=FIRST_ID,

   if(DOC_TYPE<>14, if(SOURCE_IDX<>7, ITEM)))))),ITEM)

[mohamed_ahid]

us only() function in this case .

can you send a sample file ?

[#4]

USE THE LITTLE TABLE... I CANNOT GIVE THIS DATA

[#5]

DOESN'T WORK

[anbu1984]

Check this app