I am needing help with using the dbr.calc utilizing the dbr.hdr command, below is some example code.
select 'dbr.hdr', '[n]';
select 'dbr.crosstab', '[dt]';
select 'dbr.calc', '[total_pct]','[data_column]/[total_column.sum]*100';
select 'dbr.hidecolumn', '[data_column]', '[total_column]'; select agent_name as 'Agent Name[n]',
client_status as 'Client Status[st],
date as 'Date[dt]',
null as 'Total %[total_pct]',
data_column as '[data_column],
total_column as '[total_column]'
group by 1,2,3;
If I have more than one name then it shows subtotals and the total. What I am trying to do is to perform the dbr.calc command based on the vertical sum for each individual name. So if I have multiple names on this report then it calculates the formula based on all the names as a whole instead of each individual person which is what my goal is. I may be talking in circles so please let me know if you need further clarification.