Hi,
Is it possible to display a field as a percentage of the column total. I am trying to create a simple report that shows Department, Sales and % of Total Sales that I can filter by date, i.e.
Between 01/06/2006 and 30/06/2006
--------------- Dept1, $50, 62.50% Dept2, $10, 12.50% Dept3, $20, 25.00%
I can't precalculate the values because they can change depending on the date filter. I pretty new to modifying reports in RMS so any help would be greatly appreciated.