Hello,
I have a current issue with trying to use a table to add two new columns to a pivot table. The pivot table pulls all the needed information, but the order needs to have a discounted column and a discounted total column for new pricing. the discounted column is manually entered and the discounted total column will need to multiply the discount column and the quantity column, which is in the pivot table.
Is there a way to add two columns in table format that update the needed rows with how many rows the pivot tables are using. the pivot table changes length depending on the amount of product the customer is ordering. I have been coming up short on finding any solutions or threads that have addresses this before. I do not think a power query will work in this instance, unless you can manually add data to a column of a power query.
Thank you,
Mack
I have a current issue with trying to use a table to add two new columns to a pivot table. The pivot table pulls all the needed information, but the order needs to have a discounted column and a discounted total column for new pricing. the discounted column is manually entered and the discounted total column will need to multiply the discount column and the quantity column, which is in the pivot table.
Is there a way to add two columns in table format that update the needed rows with how many rows the pivot tables are using. the pivot table changes length depending on the amount of product the customer is ordering. I have been coming up short on finding any solutions or threads that have addresses this before. I do not think a power query will work in this instance, unless you can manually add data to a column of a power query.
Thank you,
Mack