I’d like to calculate the percentage ratio of dimension members but… it should be time dynamic …
What I have so far…
Sum (PeriodsToDate ( [Times].[Timeline].[Year
ID], [Times].[2010-09-03] ),[Measures].[Encounter Count])
), Format = "Percent"
The query above should show for each hospital the ratio of the patient encounters form 01-01-2010 to 09-03-2010.
The issue I have is the denominator
The way the query above is written the denominator includes all the encounters for all times and that doesn’t makes sense. I’d
like the total encounters over all hospitals also from 01-01-2010 to 09-03-2010…I tried different options to accomplish this but nothing worked so far…
Any hint into the right direction would be much appreciated…
Thx a bunch
View Complete Post