Crosstab question 1

[BigC72]

I am using CR 11 to query a DB2 database. I have inserted a crosstab that is grouping all charges posted for our physicians and displaying them as a total for that particular date and also totalling down the column (date) to give me a daily total and accross the row (physician) to give me a running total for the period. Then of course both of these totals add up to a grand total. What I would like to accomplish is to add a field for each column directly underneath the daily total that indicates the percentage that days total is of the grand total for the period in question (normally month to date). Even with CR 11 I've been unable to come up with a way to do this. I can add a percentage to each docs daily total that gives me what that docs total for the day is in relation to the days total posted charges but that's not quite what I'm after. Thanks in advance for any assistance...

 

[lbass]

The following seems to work in CR XI. Create a formula {@percentgrtot}:

{table.chg} % sum({table.chg})

Add this as a summarized field with sum as the summary. In preview mode, select the summary and then click on the % icon.

-LB

 

[BigC72]

Thanks LB perfect solution!!!