Hello...
I have a report that I would like to calculate the percentage of the total. I am listing Vendors that have a certain Classification, their dollar amount for a specific month, and would like to determine the % of the Grand Total for the classification, for each vendor.
I was wondering if it was possible to use a variable that I have already given a value to (i.e., v_total_amount), and use it in an R1C1 Formula? I cannot figure out any other way to do this since the number of Vendors changes each time I run the report, depending on the classification that is run.
Any help anyone could give me would be much appreciated.
Thanks!!
I have a report that I would like to calculate the percentage of the total. I am listing Vendors that have a certain Classification, their dollar amount for a specific month, and would like to determine the % of the Grand Total for the classification, for each vendor.
I was wondering if it was possible to use a variable that I have already given a value to (i.e., v_total_amount), and use it in an R1C1 Formula? I cannot figure out any other way to do this since the number of Vendors changes each time I run the report, depending on the classification that is run.
Any help anyone could give me would be much appreciated.
Thanks!!