I am having problem to calculate the % value on the base of subtotal per each row and in the column.
As you may see from the snap shot# 1, I am unable to calculate the percentage value basing upon the sub-total value (i.e. from the 1st row).
And this is how i want to s开发者_如何学Chow my output as shown below snapshot.
I found the answer for the above question calculating the percentage based on the subtotal for inscope values.
=FormatPercent(Sum(Fields!StartingInventory.Value)/Fields!Sum_StartingInventory.Value,1)
精彩评论