The issue is I need Columns F,G, & H to be on Row 3 not Row 2 This is separate data from a separate table than columns B, C, D. Thanks
So I was able to find a work around. I used the Pivot table and created formulas below it using the data above so that I could Map them to the Dashb...
The issue is that I can't use Data from a PIVOT Table because the Dashboard gives me the Error in the Attached Image. Thanks for the help. Regar...
HI Riny, Thank you for that assistance. The only issue is I need to be able to print the information on 1 Sheet of paper (11 X 17) to Display it o...
DISREGARD!!! I figured out what happened. Somehow all was unchecked for the Document ID indicator and that was preventing it from pulling all the data...
Hey Mynda, One question I did have though: How do I add additional tables to my Power Query?? Can I just edit the query and add additional tables as...
Thank you Mynda, I got them formatted properly and was able to run the query. I also figured out how to get the query to give me totals by date whic...
Hi Mynda, What do you mean they're not Excel Tables?? They're tables that were created and formatted in Excel
Hi Mynda, Yes there are pivot tables, but I'm not pulling the data from the pivot tables, but the actual data sheets that the pivot tables connect to...
SO I was able to figure out the differences between our versions of Excel and try using Power Query. When I use the "=Excel.CurrentWorkbook ()" formu...
Good morning Mynda, Thank you for the response. I don't have the same toolbar as you in my Office 2016: (FYI I am working on a corporate machine)>...