Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one attached qvw.
So I want only two record that is 345 -
456 -
thanks
Hi vijay, in a List Box you can get those values with:
=Aggr(If(Count([INVOICE NO])=1, [INVOICE NO]), [INVOICE NO])
You also can use this expression in a calculated dimension.
Hi vijay, in a List Box you can get those values with:
=Aggr(If(Count([INVOICE NO])=1, [INVOICE NO]), [INVOICE NO])
You also can use this expression in a calculated dimension.
Hi Ruben,
This is only for two records if I have thousands of record then....
pls check below
INVOICE NO | PO_NO |
123 | A |
123 | D |
123 | A |
123 | A |
123 | |
123 | |
234 | B |
234 | B |
234 | |
234 | |
345 | |
456 | |
678 | D |
678 | |
678 | |
998 | |
984 | |
659 | |
224 | |
123 | |
333 | |
555 | |
555 | |
125 | |
147 | |
985 | |
123 | B |
234 | |
678 | C |
111 | |
111 | |
111 | B |
111 |
Thanks
Hi vijay, from the data and result expected I supposed you want the records wich aren't repeated, if this is what you want the same expression can work, if there is a different requirement..what' the requirement?
For the last data, using the same expression I get: