ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

DrillDown function

DrillDown function

½Ð°Ý¦pªG¦bsheets1 = summary, ¨C­Óitem code ³£¦³sub code, ¦Ósubcode¤J­±·|¦³«Ü¦hdetails («Ü¦h¦æªº), ¥i§_·í§Ú·Q¬Ýitems 1®É, click items 1«K¥i¶i¤J¸Ì­±ªº²Ó¶µ, ´N¹³Pivot table¤@¼Ë, ¦p¦bexcel¬O¥i¥H«ç¼Ë³]©w??

ÁÂÁ¦U¦ì°ª¤â

¥»©«³Ì«á¥Ñ kimbal ©ó 2012-7-15 09:25 ½s¿è

¥ÎExcelªºsubtotal(¦Û°Ê ¤p­p) ¥\¯à¦p¦ó?
https://sites.google.com/site/ex ... pofitemwithsubtotal
­ø«Y´N­n¼gÀ\»X
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

        ÀR«ä¦Û¦b : ¤p¨Æ¤£°µ¡B¤j¨ÆÃø¦¨¡C
ªð¦^¦Cªí ¤W¤@¥DÃD