Search results

solved

figured out the problem but still have an issue. I just realized because in the report it has both sales and return sales(sales value of the items returned within that order) was why it wouldn't sum correctly since there were blank rows under sales if that order had a return tied under it...

I'm trying to make a pivot table and in it I have four columns of data, along with a number of other fields. Those four columns are all formatted as a number. When I create the PT and try to do a summation on those fields it treats them like a text field and only does a count. Any ideas on...

Sorry about that Wally...I was trying to rename everything in the orig formula to match the ex file I made. Bosco...that was perfect. really appreciate it. Is there a way to make this thread as closed?

this is also posted at: https://www.mrexcel.com/forum/excel-questions/987230-help-formatting-index-match-count.html#post4736895 http://www.excelforum.com/showthread.php?t=1170978&p=4566572#post4566572

Hi all, I'm trying to use an index matching to move over some pricing data. This formula worked last year but won't work this year for some reason. the formula I'm using is...

Also posted this at: http://www.excelforum.com/showthread.php?t=1143916&p=4412913#post4412913

When I'm using PP and trying to bring down data from the SQL server I'm using the following code: SELECT BILLING.BILLING_SOLD_ACCNO, BILLING.BILLING_ORIG_ORDNO, BILLING.BILLING_ORIG_ORD_DATE, BILLING.BILLING_ORIG_OPR, BILLING_ORDER_ITEMS.BILLING_ITEM FROM BILLING INNER JOIN BILLING_ORDER_ITEMS...

Solved.

Appreciate the help but I have to have it where there are not blank cells before or in between the items. I have to take the items here and put them into a number workbook after this for something else and those blanks would cause problems in step 2.

I also posted this in two other locations: http://www.excelforum.com/showthread.php?t=1143602&p=4411163#post4411163 http://www.mrexcel.com/forum/excel-questions/947257-simple-transpose-help.html#post4550651

Hello, I've tried tranposing this data a couple times and keep getting errors. Hoping a fresh pair or eyes will be able to do it for me. In the attachment there is a start and finish sheet so you can see how the data currently is and how I'd like it to look. Where every line that the order...

thank you for all the help

Sweet that worked....really appreciate all the help man. 1 quick side question. When I'm in PP manage is there a quicker way to delete unwanted fields without having to highlight columns and right click delete since it doesn't allow you to scroll across.

I'll give that a shoot.

Ok found it...not sure how I missed that under the data tab. and it's ProPlus. Yeah I uninstalled office and reinstalled it from office 365 so it's all 64 bit. Last question....I hope lol. When I goto get & transform>new Query>other sources>ODBC...it asks for a connection string. What is...

hmm when I downloaded 64 bit office from microsoft 365 it ended up downloading 2016 office. it says power query comes with it in the data tab but I can't seem to find it. Can I still do what you were suggesting with 2016?

Didn't realize we had office 365...I can just download the 64 bit version from there and I should be good to go.

Do you know anyone who has done that and it worked or if they ran into any problems? Got our IT guy at work right now looking to see if he can find a copy of 64 bit 2013 excel but I don't think there's a copy here.

I tired just doing the load as load connection instead of bringing the table into excel first. On a smaller table, ~50,000 rows, it works fine and creates the connection for me to use in PP. But the tables I need are much bigger tables, ~700,000 lines in each table. When I try doing those two...

It won't let me load the entire first table to the spreadsheet or data model. Just says load failed.

Crap wouldn't load the first table. Got to ~640,000 rows then had an error and couldn't load anymore.

I need 2 tables from an ODBC connection and 1 excel sheet all coming into the PP. I'm assuming for the power query just load both tables I need from ODBC which creates 2 sheets, one for each. So then have 3 total sheets and use data loaded in PP to bring in all 3 sheets to set my connections...

I see add to data model in PowerPivot but can't find the power query anywhere. Do you just mean using the MS query to bring in the info and then using add to data model in PP to bring over what I need into PowerPivot? And I'm using 2013 excel

Also posted this topic at: http://www.excelforum.com/showthread.php?t=1140034&p=4390739#post4390739 http://www.mrexcel.com/forum/excel-questions/942212-power-pivot-help-1st-time-user-here.html#post4526210