I am using Excel 2016.
I added a column to the data set that my Pivot Table is pulling from and one of the calculations is giving me a #NAME ? error now. How can I fix this? The columns I am using are below. The error is in the third column (Invoice+Orders % Budget). The column I added is Net Sales 2. I tried changing the name of Net Sales 2, but that did not work.
<tbody>
</tbody>
Thanks,
Rodney
I added a column to the data set that my Pivot Table is pulling from and one of the calculations is giving me a #NAME ? error now. How can I fix this? The columns I am using are below. The error is in the third column (Invoice+Orders % Budget). The column I added is Net Sales 2. I tried changing the name of Net Sales 2, but that did not work.
BUDGET | INVOICE + ORDERS VS BUDGET $ | INVOICE + ORDERS % BUDGET | NET SALES | NET ORDERS | INVOICE + ORDERS | FORECAST | INVOICE + ORDERS VS FORECAST $ | INVOICE + ORDERS % FORECAST |
<tbody>
</tbody>
Thanks,
Rodney