TOTAL qualifier with Calculated dimensions

[#1]

Hi everybody,

I have created two calculated dimension ClusterDiscount and ClusterSpending.

For each ClusterDiscount I need to know the following:

Count ([# Orders]) /Count (TOTAL <ClusterSpending> [# Orders])

I realize that the TOTAL Qualifier does not work since ClusterDiscount and ClusterSoending are two calculated dimensions.

Is there anyway to bypass the problem?

ClusterSpending

=if(([Net Price)])<100,'A',
if( ([Net Price])<300,'B',
if( ([Net Price])<1000,'C',
if( ([Net Price])<3000,'D',
if( ([Net Price])<5000,'E','F')))))

ClusterDiscount

=if(-( ([ToTDiscount])/ ([TotPriceList]))< 0,'Over',
if(-( ([ToTDiscount])/ ([TotPriceList]))<0.1,'0-9',
if(-( ([ToTDiscount])/ ([TotPriceList]))<0.3,'10-29',
if(-( ([ToTDiscount])/ ([TotPriceList]))<0.5,'30-49',
if(-( ([ToTDiscount])/ ([TotPriceList]))<0.7,'50-69',
if(-( ([ToTDiscount])/ ([TotPriceList]))<0.9,'70-89',
if(-( ([ToTDiscount])/ ([TotPriceList]))< 1,'90-99','Omaggio')))))))

Thanks in advance

Emanuele

[sunny_talwar]

How about this?

Count ([# Orders]) /Count (TOTAL <[Net Price]> [# Orders])