count distinct with excluded dimensions ..help

[prees959]

Hi,

Im trying to use the following expression to display a 100% stacked bar chart :

Count( distinct  {<[Type]={'OuterPerimeter'}>}  PKEY) /

count(distinct <Date, [Fiscal Week],[Year_Month],[Year_Week],[Fiscal Yr],[Fiscal Qtr],[Fiscal Month],DayOfWeek> [ID])

but I'm getting an error on the :

count(distinct <Date, [Fiscal Week],[Year_Month],[Year_Week],[Fiscal Yr],[Fiscal Qtr],[Fiscal Month],DayOfWeek> [ID])

Can anyone advise how to correctly formulate this expression please?

Many thanks,

Phil

[luismadriz · Accepted solution]

count(distinct {<Date=, [Fiscal Week]=,[Year_Month]=,[Year_Week]=,[Fiscal Yr]=,[Fiscal Qtr]=,[Fiscal Month]=,DayOfWeek=>} [ID])

I hope this helps,

Luis

[prees959]

thanks so much!

Works perfectly

Phil