I have a "form" whose function is to gather qualitative input. Quantitative data is prepopulated and if certain criteria are met, a comment is to be entered. Here is a simple representation of the form data. Column D is what I want to capture and archive.
Form data from 5/1/22
Product...
Just to check back in--I believe I figured it out. I do need to merge tables. I have a set of products each with monthly forecast dates and separate production dates. Adding those separate date fields to a pivot table does not work as I had hoped.
Yes--ultimately the intent is to pivot. I don't necessarily want to merge tables--just merge in a pivot so I can drop in a product and see actuals back 12 mos and forecast forward 12 mos.
Thanks for the response!
I am just getting started with Power Query. I have 3 tables:
Product ID
Actual Sales
Forecast Sales
Actual Sales has historical actual data by product by month. Lets say the data goes back 12 months. Forecast has monthly data by product going forward 12 months.
Product ID has the product...
I have several horizontally oriented charts in a simple dashboard sheet. In some cases there is only one data series. Is there a way to duplicate the primary axis markers in the secondary axis.
Alternatively, is there a way to display the axis markers to the secondary axis when there is...
Hello. Thanks be to Chandoo.org. It is as helpful as Excel itself.
I am now using Excel 2010. My preference for currency formats is accounting format with no symbol, 2 decimal places with the comma separators.
Can I make that the default format when I hit the $ in the ribbon? As it...
I have built a sheet with client accounts in cells A2:A5000. Starting in column E & F, I have monthly sales and gross profit for each client. E&F is December, G&H January, I&J Feb....AE&AF Jan'10.
After column A there are total sales & total profit columns.
I want to use the subtotal...