开发者

I am having problem to calculating % on base of subtotal value in Matrix in SSRS Report

开发者 https://www.devze.com 2023-01-24 04:31 出处:网络
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 th

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).

I am having problem to calculating % on base of subtotal value in Matrix in SSRS Report

And this is how i want to s开发者_如何学Chow my output as shown below snapshot.

I am having problem to calculating % on base of subtotal value in Matrix in SSRS Report


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)

0

精彩评论

暂无评论...
验证码 换一张
取 消