��ʲô�Y(ji��)����(hu��)��һ���������� EVALUATE var tab1=ADDCOLUMNS��SUMMARIZE��'�N�۱�','�a(ch��n)Ʒ��'[�a(ch��n)Ʒ��]��,"����(sh��)",calculate��SUM��'�N�۱�'[��(sh��)��]������ var tab2=ADDCOLUMNS��tab1,"�ȼ�(j��)",switch��true����,[����(sh��)]>=500,"500����",[����(sh��)]>=100,"100~500","100����"���� var tab3=SUMMARIZE��tab2,[�ȼ�(j��)],"Ӌ(j��)��(sh��)",COUNT��'�a(ch��n)Ʒ��'[�a(ch��n)Ʒ��]���� RETURN tab3

����GROUPBY�cSUMMARIZE����һ��(g��)�����g���� ���@��(g��)�����ڽ������^�m(x��)��Ӌ(j��)����

EVALUATE var tb1=ADDCOLUMNS��SUMMARIZE��'�N�۱�','�a(ch��n)Ʒ��'[�a(ch��n)Ʒ��]��,"����(sh��)",CALCULATE��SUM��'�N�۱�'[��(sh��)��]������ var tb2=ADDCOLUMNS��tb1,"�ȼ�(j��)",SWITCH��TRUE����,[����(sh��)]>=500,"500����",[����(sh��)]>=100,"100~500","100����"���� //var tb3=GROUPBY��tb2,[�ȼ�(j��)],"ӛ䛔�(sh��)",COUNTAX��CURRENTGROUP����,[�ȼ�(j��)]���� var tb3=ADDCOLUMNS��SUMMARIZE��tb2,[�ȼ�(j��)],"ӛ䛔�(sh��)",CALCULATE��COUNTA��[�ȼ�(j��)]�������� RETURN tb3 �@�ӌ�tb3��(b��o)�e(cu��),��ô̎��