November 5, 2012 at 11:27 am
Hello,
I am probably missing something here - but have been beating my head against the wall for a while now and have not managed to come up with anything.
I have a Reporting Services 2008 report that is using a matrix that shows a product and the types of customers that have been sold to, and shows a percentage amount for each customer type...then the matrix is used to spread out to the right for mutliple months.
Eg:
Jan Feb March
Product A Type1 10% 20% 5%
Type2 20% 30% 80%
Type3 70% 50% 15%
The source data is based on qty sold, not percentages; therefore I have a hidden field on the report that holds the sumed qty sold for each month, which is used to drive the percentage values shown in the report (eg the percentage field in the report =Sum(Fields!Product_Quantity.Value)/ReportItems!Textbox44.Value)....where Textbox44 = Sum(Fields!Product_Quantity.Value) )
This is all working fine. However when I try and add a graph to visually represent the data it all turns pear shaped. I am wanting a bar graph, with category groups for the customer type value, and series grouping for the month. Y axis to show percentage - just as in the matrix. Not anything overly complex I wouldn't have thought.
The expression I have set for the "value" in the graph is the same expression as above to calculate the percentage in the matrix (=Sum(Fields!Product_Quantity.Value)/ReportItems!Textbox44.Value). The problem is that when the graph is drawn it would appear as though the Textbox44 reference is not locked to the month, so the report always uses the value in Textbox44 for the last month (right most column), and not the month that it needs to be.
Thanks for any help anyone can offer on this front - I think I might have confused the situation a little, but let me know if you have any questions/ideas/help/etc.
Thanks in advance
November 5, 2012 at 4:14 pm
I have a funny feeling that the problem is that it is not possible to work out the percentage value of a value based on both the column group and the row group
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply