October 7, 2010 at 2:28 pm
I am new to SQL and SSRS and I am trying to create a matrix with 2 Column group levels and each with a total. I have been able to accomplish that feat. Hoever now I need to calculate the % of the group level for each of the counts
for example:
__________ColumnGroup1(Red)________/__ColumnGroup1(Blue)____________
___/__(A)__/___(B)__/__(C)__/__Total_/__(A)__/__(B)__/__(C)__/__Total__/
RG_/___1___/____2__/___3___/___6___/___3___/___3__/___3___/___9____/
RG_/___2___/___2___/___9___/___13__/___1___/___4___/__6___/___11___/
when I try to calculate a percent it is going down the columns, but I want to calculate the percent of the total for each group ie A is % of Total, B is percent of Total, etc (1/6 = 16.7%, 2/6=33.3%)
I thought I had the answer but I got a fatal error and lost the changes. I cannot seem to reproduce them.
Any help would be appreciated.
October 8, 2010 at 7:28 am
bumping this to try to get help
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply