how to do like "total colA for distinct colB"?

mc09 · 08 Jun 2009 09:35:35 AM

is there any way to do in this way?

dumbell · 14 Jun 2009 07:38:35 AM

This will be total 3 calculations.

(1)Total(ColA)
(2)distinct (ColB)
(3)aggregate(1) for (2)

Let me know, how it goes?

BSP Software	Resources	About Us
MetaManager	BSP Software Training	BSP Software
Integrated Control Suite	YouTube Channel	Micro Strategies Inc
Security Migration		IBM Cognos
Integrated Management Suite

If you are unable to create a new account, please email support@bspsoftware.com