This is a migrated thread and some comments may be shown as answers.

percentage of each item in crosstab

1 Answer 204 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Quan Nguyen
Top achievements
Rank 1
Quan Nguyen asked on 25 Mar 2011, 05:48 PM
Hi,
I have some problem using crosstab to display the percentage of number of items against the total of each group. Right now it's calculating agains the total count of the entire report.
Attach is my screenshot with explaination.

Thanks
Quan Nguyen

1 Answer, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 30 Mar 2011, 04:27 PM
Hello Quan Nguyen,

You are on the right track with the Exec function however as a scope our suggestion is to use the corresponding Crosstab group to get the expected data. I am not sure about the names of your Crosstab groups but it should look something like: = Exec("MailQuantityGroup",Count(Fields.Renew)). You can use the Group Explorer to examine the groups.

Up to the red Textbox you can't remove however you can merge both textboxes/cells by selecting them and from the context menu select Merge Cells option.

About adding a new column our suggestion is to select the Crosstab column that contains the Total Renewal Counts and from the context menu select Insert Column->Left option.

Best wishes,
Peter
the Telerik team
Tags
General Discussions
Asked by
Quan Nguyen
Top achievements
Rank 1
Answers by
Peter
Telerik team
Share this question
or