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
