Subtotal error on calculated field in a Reporting Services Matrix
Posted
by peacedog
on Stack Overflow
See other posts from Stack Overflow
or by peacedog
Published on 2009-03-05T20:11:12Z
Indexed on
2010/03/13
14:15 UTC
Read the original article
Hit count: 956
I've got a Reporting Services report that has two row groups: Category and SubCategory. For columns it has LastYearDataA, ThisYearDataA, LastYearDataB, ThisYearDataB.
I added two columns (one for A and one for B) to handle an expression calculation (to show a percentage different from LastYear to ThisYear for each). That's working. The problem comes in the SubTotal for each category. The raw numbers are totaling correctly. If SubCat1 has 10//5 for LastYear/ThisYear A, and SubCat2 has 5//1, then I get 15/5 for the totals. But I get the percentage reported in the total column as "50%", matching SubCat1. Percentages for each Subcategory are being calculated correctly (according to my backup math, anyway). But the sub total % always matches the first SubCategory in the group. Is this impossible to do in Reporting Services 2005?
© Stack Overflow or respective owner