Aligning Line total to the right

[Q1983]

proc report data=post_deploy_3 nowd;

columns SALE_REP_NM acct_exec_nm THRD_PARTY_ORIG_NM THRD_PARTY_ORIG_CD Total_Count;

define SALE_REP_NM/ group Display style(column)={cellwidth=60pt just=center} "CRC" ;

define Total_Count/analysis sum ;

compute after;

THRD_PARTY_ORIG_CD = "Total";

line "Total" Total_Count.sum ;

endcomp;

run;

The code works fine however the Total_Count (label=Grand Total) at the bottom needs to display under the total column.  Sample data enclosed.  It display near the middle of the bottom

[JerryLeBreton]

Try this:

rbreak after / summarize;
compute after ;
  if _break_  = '_RBREAK_' then THRD_PARTY_ORIG_CD = 'Total';
endcomp;

If I understand what you're trying to do, this should give a last line with the total in the correct column, and the  word 'Total' in the column immediately to the left of the total value.

[Q1983]

Jerry you are a genious, thanks it worked, I will add this to my coding tips list