OLAP cube question

S

Simon Dullingham

I'm trying to define an s-curve as an analyzer view, but I want the curve to
be in %, not in raw hour. The current calculation that I am using is

Sum(PeriodsToDate([Time].[All]),[Work])

This gives me the total number of hours in each period (month/quarter/year).

But what I want to do is have some thing like

Sum(PeriodsToDate([Time].[All]),[Work])/[total work]

Does anyone have any suggestions?

Thanks,
Simon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top