Dear BHQ,
Semua tergantung kriteria yang dibandingkan. Jika ingin Count sesuatu yang unique, maka buat kriteria unique sebagai data yang di-count. Prinsipnya : Count() = Sum(IF(kriteria,1,0))
Semoga file terlampir bisa lebih menjelaskannya.
A AAABAAUBQQByAGkAYQBsADEAGgDIAAEA/3+8AgAAAAIAAAUBQQByAGkAYQBsADEAGgDIAAAA/3+Q AQAAAAABAAUBQQByAGkAYQBsADEAHgBoAQEAOAC8AgAAAAIAigcBQwBhAG0AYgByAGkAYQAxAB4A LAEBADgAvAIAAAACAIoHAUMAYQBsAGkAYgByAGkAMQAeAAQBAQA4ALwCAAAAAgCKBwFDAGEAbABp AGIAcgBpADEAHgDcAAEAOAC8AgAAAAIAigcBQwBhAGwAaQBiAHIAaQAxAB4A3AAAABEAkAEAAAAC AIoHAUMAYQBsAGkAYgByAGkAMQAeANwAAAAUAJABAAAAAgCKBwFDAGEAbABpAGIAcgBpADEAHgDc AAAAPACQAQAAAAIAigcBQwBhAGwAaQBiAHIAaQAxAB4A3AAAAD4AkAEAAAACAIoHAUMAYQBsAGkA YgByAGkAMQAeANwAAQA/ALwCAAAAAgCKBwFDAGEAbABpAGIAcgBpADEAHgDcAAEANAC8AgAAAAIA igcBQwBhAGwAaQBiAHIAaQAxAB4A3AAAADQAkAEAAAACAIoHAUMAYQBsAGkAYgByAGkAMQAeANwA AQAJALwCAAAAAgCKBwFDAGEAbABpAGIAcgBpADEAHgDcAAAACgCQAQAAAAIAigcBQwBhAGwAaQBi AHIAaQAxAB4A3AACABcAkAEAAAACAIoHAUMAYQBsAGkAYgByAGkAMQAeANwAAQAIALwCAAAAAgCK BwFDAGEAbABpAGIAcgBpADEAHgDcAAAACQCQAQAAAAIAigcBQwBhAGwAaQBiAHIAaQAxAB4A3AAA AAgAkAEAAAACAIoHAUMAYQBsAGkAYgByAGkAMQAcAKAAAABRAJABAAAAAAGKBgFUAGEAaABvAG0A YQAxABwAoAABAFEAvAIAAAAAAYoGAVQAYQBoAG8AbQBhADEAHACgAAEAUQC8AgAAAAIAigYBVABh AGgAbwBtAGEAMQAaAMgAAAD/f5ABAAAAAgCKBQFBAHIAaQBhAGwAMQAcAKAAAABRAJABAAAAAgCK BgFUAGEAaABvAG0AYQAeBBgABQATAAAioyIjLCMjMDtcLSKjIiMsIyMwHgQdAAYAGAAAIqMiIywj IzA7W1JlZF1cLSKjIiMsIyMwHgQeAAcAGQAAIqMiIywjIzAuMDA7XC0ioyIjLCMjMC4wMB4EIwAI AB4AACKjIiMsIyMwLjAwO1tSZWRdXC0ioyIjLCMjMC4wMB4ENQAqADAAAF8tIqMiKiAjLCMjMF8t O1wtIqMiKiAjLCMjMF8tO18tIqMiKiAiLSJfLTtfLUBfLR4ELAApACcAAF8tKiAjLCMjMF8tO1wt KiAjLCMjMF8tO18tKiAiLSJfLTtfLUBfLR4EPQAsADgAAF8tIqMiKiAjLCMjMC4wMF8tO1wtIqMi KiAjLCMjMC4wMF8tO18tIqMiKiAiLSI/P18tO18tQF8tHgQ0ACsALwAAXy0qICMsIyMwLjAwXy07 XC0qICMsIyMwLjAwXy07Xy0qICItIj8/Xy07Xy1AXy0eBB4ApAAZAAAiUnAiIywjIzBfKTtcKCJS cCIjLCMjMFwpHgQjAKUAHgAAIlJwIiMsIyMwXyk7W1JlZF1cKCJScCIjLCMjMFwpHgQkAKYAHwAA IlJwIiMsIyMwLjAwXyk7XCgiUnAiIywjIzAuMDBcKR4EKQCnACQAACJScCIjLCMjMC4wMF8pO1tS ZWRdXCgiUnAiIywjIzAuMDBcKR4EOgCoADUAAF8oIlJwIiogIywjIzBfKTtfKCJScCIqIFwoIywj IzBcKTtfKCJScCIqICItIl8pO18oQF8pHgQuAKkAKQAAXygqICMsIyMwXyk7XygqIFwoIywjIzBc KTtfKCogIi0iXyk7XyhAXykeBEIAqgA9AABfKCJScCIqICMsIyMwLjAwXyk7XygiUnAiKiBcKCMs IyMwLjAwXCk7XygiUnAiKiAiLSI/P18pO18oQF8pHgQ2AKsAMQAAXygqICMsIyMwLjAwXyk7Xygq IFwoIywjIzAuMDBcKTtfKCogIi0iPz9fKTtfKEBfKeAAFAAAAAAA9f8gAAAAAAAAAAAAAADAIOAA FAABAAAA9f8gAAD0AAAAAAAAAADAIOAAFAABAAAA9f8gAAD0AAAAAAAAAADAIOAAFAACAAAA9f8g AAD0AAAAAAAAAADAIOAAFAACAAAA9f8gAAD0AAAAAAAAAADAIOAAFAAAAAAA9f8gAAD0AAAAAAAA AADAIOAAFAAAAAAA9f8gAAD0AAAAAAAAAADAIOAAFAAAAAAA9f8gAAD0AAAAAAAAAADAIOAAFAAA AAAA9f8gAAD0AAAAAAAAAADAIOAAFAAAAAAA9f8gAAD0AAAAAAAAAADAIOAAFAAAAAAA9f8gAAD0 AAAAAAAAAADAIOAAFAAAAAAA9f8gAAD0AAAAAAAAAADAIOAAFAAAAAAA9f8gAAD0AAAAAAAAAADA IOAAFAAAAAAA9f8gAAD0AAAAAAAAAADAIOAAFAAAAAAA9f8gAAD0AAAAAAAAAADAIOAAFAAAAAAA AQAgAAAAAAAAAAAAAADAIOAAFAAYAAAA9f8gAAC0AAAAAAAAAASfIOAAFAAYAAAA9f8gAAC0AAAA AAAAAAStIOAAFAAYAAAA9f8gAAC0AAAAAAAAAASqIOAAFAAYAAAA9f8gAAC0AAAAAAAAAASuIOAA FAAYAAAA9f8gAAC0AAAAAAAAAASbIOAAFAAYAAAA9f8gAAC0AAAAAAAAAASvIOAAFAAYAAAA9f8g AAC0AAAAAAAAAASsIOAAFAAYAAAA9f8gAAC0AAAAAAAAAASdIOAAFAAYAAAA9f8gAAC0AAAAAAAA AASLIOAAFAAYAAAA9f8gAAC0AAAAAAAAAASuIOAAFAAYAAAA9f8gAAC0AAAAAAAAAASsIOAAFAAY AAAA9f8gAAC0AAAAAAAAAASzIOAAFAAXAAAA9f8gAAC0AAAAAAAAAASeIOAAFAAXAAAA9f8gAAC0 AAAAAAAAAASdIOAAFAAXAAAA9f8gAAC0AAAAAAAAAASLIOAAFAAXAAAA9f8gAAC0AAAAAAAAAASk IOAAFAAXAAAA9f8gAAC0AAAAAAAAAASxIOAAFAAXAAAA9f8gAAC0AAAAAAAAAAS0IOAAFAAXAAAA 9f8gAAC0AAAAAAAAAAS+IOAAFAAXAAAA9f8gAAC0AAAAAAAAAASKIOAAFAAXAAAA9f8gAAC0AAAA AAAAAAS5IOAAFAAXAAAA9f8gAAC0AAAAAAAAAASkIOAAFAAXAAAA9f8gAAC0AAAAAAAAAASxIOAA FAAXAAAA9f8gAAC0AAAAAAAAAAS1IOAAFAANAAAA9f8gAAC0AAAAAAAAAAStIOAAFAARAAAA9f8g AACUERGXC5cLAASWIOAAFAATAAAA9f8gAACUZma/H78fAAS3IOAAFAABAKsA9f8gAAD4AAAAAAAA AADAIOAAFAABAKkA9f8gAAD4AAAAAAAAAADAIOAAFAABAKoA9f8gAAD4AAAAAAAAAADAIOAAFAAB AKgA9f8gAAD4AAAAAAAAAADAIOAAFAAVAAAA9f8gAAD0AAAAAAAAAADAIOAAFAAMAAAA9f8gAAC0 AAAAAAAAAASqIOAAFAAJAAAA9f8gAADUAFAAAAAfAADAIOAAFAAKAAAA9f8gAADUAFAAAAALAADA IOAAFAALAAAA9f8gAADUACAAAAAPAADAIOAAFAALAAAA9f8gAAD0AAAAAAAAAADAIOAAFAAPAAAA 9f8gAACUERGXC5cLAASvIOAAFAASAAAA9f8gAADUAGAAAAAaAADAIOAAFAAOAAAA9f8gAAC0AAAA AAAAAASrIOAAFAAHAAAA9f8gAACcEREWCxYLAASaIOAAFAAQAAAA9f8gAACUERG/H78fAASWIOAA FAABAAkA9f8gAAD4AAAAAAAAAADAIOAAFAAIAAAA9f8gAAD0AAAAAAAAAADAIOAAFAAWAAAA9f8g AADUAGEAAD4fAADAIOAAFAAUAAAA9f8gAAD0AAAAAAAAAADAIOAAFAAAAAAAAQAgAABAAAAAAAAA AAQNIOAAFAAAAAAAAQAgAABAAAAAAAAAAAQ0IOAAFAAAAAAAAQAiAAAQAAAAAAAAAADAIOAAFAAG AAAAAQAgAAAIAAAAAAAAAADAIOAAFAAAAAAACQAgAAAAAAAAAAAAAADAIOAAFAAcAAAAAQAgAABI AAAAAAAAAAYNIOAAFAAAAA4AAQAgAABEAAAAAAAAAAYNIOAAFAAAAAAAAQAgAABAAAAAAAAAAAYN IOAAFAAAAAAAAQAgAAAgEQBAIAAAAADAIOAAFAAAAAAAAQAgAAAgERBAIAAgAADAIOAAFAAcAAAA AQAgAABoERFAIEAgAAYNIOAAFAAAAAAAAQAgAAAgERFAIEAgAADAIOAAFAAcAAAAAQAiAAA4ERFA IEAgAADAIHwIFAB8CAAAAAAAAAAAAAAAAEsAZBiYEX0IQQB9CAAAAAAAAAAAAAAAABAAAAADAA0A FAADAAAAAQAAADAwXCk