Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
|
| 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
=Aggr(count(DISTINCT( if(ENTRYDATE=ORDERDATE,
if( ID=FIRST_ID,
if(DOC_TYPE<>14, if(SOURCE_IDX<>7, ITEM)))))),ITEM)
us only() function in this case .
can you send a sample file ?
USE THE LITTLE TABLE... I CANNOT GIVE THIS DATA
DOESN'T WORK
Check this app