I have an issue about using dbr.calc with Col.sum reference.
select 'dbr.dbr', 'Header';
select 'dbr.sum', 'Value'; select 'dbr.calc', 'percent', '[Value]/[Value.sum]*100'; select Header, Name, Value as '[Value]', null as 'percent' from Table order by Header;
This will divide each item with Total Value in the report, that's not what I want. I want the ratio in each Header group.
How can I do it?