I would like to create a report in table for county,Sales and % of Sales. I had created a calculated field % of Sales which is =Sales and added to the table. But whenver I changed Percentage of this column another sales field also changed in percentage. How to resolve this issue?
Can you post a workbook or at least a screenshot including the pills?