This content has been marked as final.
Show 2 replies

Pivot table partial sum issue
Erich Shiino Jul 25, 2011 2:38 PM (in response to Bikash Debnath)The actual expression you should use will depend on the field (and group) names you are using.
But if the Total Value expression is: sum (Value)
The % expression will be:
=Sum(Value)/
Sum(total <GroupName, Stage, Bucket> Value) //Where GroupName should be replaced by the name of the cyclic group on your chart.
Hope this helps,
Erich

Pivot table partial sum issue
Bikash Debnath Jul 25, 2011 5:53 PM (in response to Erich Shiino )Hi Erich,
Thanks for your answer. But it seems like the expression is not
taking the cyclic groups' name. In return its gving me all zeros.
This is what I wrote in the denominator of the expression.
sum({$<
FACT_TYPE={'Current'},
FLAG_HEALTH_REPORT={'1'},
REVENUE_RECOGNITION_FLAG ={'Yes'},
IS_PART_ACTIVE={'1'},
MODIFIED_DATE={"<=$(vMaxDate)"}
>}
total <[Group 1],STAGE, Bucket_Test> [TOTAL_VALUE])
Thanks,
