I have a calculated measure (TimeOnPhone_hhmmss) based on another
regular measure (TimeOnPhone_sec) in the cube. The calculation is
meant to convert the value presented in seconds in TimeOnPhone_hhmmss
to 'hh:mm:ss' format in TimeOnPhone_sec (ie. 3616 seconds to
01:00:16). I have successfully implemented the conversion formula,
however, there is a data presentation issue on the ProClarity side
that I have not been able to resolve.

Suppose I have the following data in the example -

TimeOnPhone_sec TimeOnPhone_hhmmss
Dad 100 00:01:40
Mom 200 00:03:20
Daughter 700 00:11:40

The problem is that when I tried to use ProClarity to display both
Subtotal and Percentage (In ProClarity, thru Properties|Values to
Display|select 'Value and Percent'). The values are always showing
100% on the fields of the calculated measure (TimeOnPhone_hhmmss). The
subtotals for both measures, as well as the percentages for the
original measure (TimeOnPhone_sec) are fine, as data shown below. But
I am not sure if there is a possibility that ProClarity could
calculate the percentage for the non-additive fields like 'hh:mm:ss'
data format. I thought since ProClarity can calculate the subtotals
based on this format, it might be possible for it to calculate the
percentage as well. The reason that I am trying to do this is to only
show the user 'hh:mm:ss' data but still allow user to view Subtotal
and Percentage in ProClarity. Can someone shed me some ight on whether
this is possible? Thanks very much in advance.

TimeOnPhone_sec TimeOnPhone_hhmmss
Dad 100 (10%) 00:01:40 (100%) -> would like (10%)
Mom 200 (20%) 00:03:20 (100%) -> would like (20%)
Daughter 700 (70%) 00:11:40 (100%) -> would like (70%)
Subtotal 1000(100%) 00:16:40 (100%)


David