Hi,
I have a PT with 4 years of data in it. I'm creating calculated fields to show the difference in sales and % of difference in sales for 2017 and 2018. Those are the only two years I'm showing in the report with Year being a column value.
Because I want to see the difference in sales between...
Hi,
I'm trying to use a formula I've used before but not it's giving me a reference error. I'm trying to move the data from sheet two over into sheet one so that instead of being on a single row it gets transposed into the column where Column A matches for both sheets.
The formulas I was using...
I'm having trouble with the countif function. In my spreadsheet in column C starting cell C2 I have text numbers. If the cell starts with an 8 I want to put a leading 0 in front of it otherwise I want to keep the cell the way it is.
Also, if possible for the cells with just a 0 in them can I...
Hi,
I'm trying to use an index match and the column where I'm trying to return data has blank cells in it. The formula I tried but didn't work was:
=INDEX(F2:F2000,IF(F2:F2000<>"",MATCH,A1,A2:A2000,0)))
The problem I'm running into is that the data I'm trying to return on an entry occurs...
I have a PT that is doing a sum of orders and sales for a given year. Also in there is the number of return orders that occurred in that year.
How can I create a calculated field to see the percentage of orders where a return occurred? When I try to do it within the actual PT in the...
Is it possible within PP to have two tables get dumped together to work with at the same time in PP? Our sales data comes from two separate tables depending on if it's been invoiced or not and I would like to take all the data as a whole to work with in PP at the same time.
Hi,
I'm trying to be able to pull out a number from column G in the attachment. What I'm needing is whenever there is not a 9 digit number in column D beginning with 100,it comes over as a text field of the server btw, then it searches column G for that number. In column G that number always...
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...
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...
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...
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...
I'm trying to set up a power pivot to dump order data into a pivot table. When I go into Manage in the Power Pivot I can not find the existing connections set up. When Normally using excel and pulling in data I just go to data>from other sources>MS query and I can see the database connections...
Please help me be able to transpose the data in the workbook I attached. One sheet has what it would currently look like (in the actual file it's about 3,000 lines) and the 2nd sheet shows how I'd like it to look.
Also posted this at...
If I have a chart with state - city - orders how can I map it on the power index so that the number of orders at each city show up on that city instead of a pie chart being put in each state with a breakdown of orders within that chart?
Also, is there a way instead of having a color coded chart...
I have an excel spreadsheet where I have duplicate email accounts with customer data. I'm trying to combine the customer data at each email account so that I can remove the dups and consolidate the customer data.
Currently I copy the emails over to a 2nd sheet and de dup. Bring over the...
If I have a table that looks like:
emailcustomer numberapples trees sports ice cream
abc@yahoo.com123 YY Y
abc@yahoo.com126
123@gmail.com858 Y
123@gmail.com767 YY
owow@yahoo.com444 Y
owow@yahoo.com455
999@yahoo.com1001 Y Y
999@yahoo.com1103 Y
999@yahoo.com 1005 Y
How...
I have a pivot table and I'm using one filter on it with thousands of keywords to look at sales data for them. Is there a way in that filter when I am searching for a keyword to be able to do a AND or OR search so that I can pull multiple different keywords at once without them being in the...
I'm trying to make a new macro for the changes in my data set to transpose my data. I attached an excel file so you can see how it looks currently. I would like it so that each item only occurs in one single row and the data is then going horizontal across the page.
I'm trying to sort this data so that Q ends up in descending order. Currently you can see it's not at AY521.
skusku1QP
AF121C60AF121C60
AK18025AK1802569
AK18025128.5
AK18025248
AK18025367.25
AB411FIRAB411FIR354
AB411FIR652
AB411FIR1250
AB411FIR2448
AE120AUSAE120AUS360
AE120AUS656.25...
I'm using a macro to transpose some data in excel. Attached is an example of the file. As you can see in it when you get to the last item in the ex the 3rd column is not sorted correctly. So I tried sorting the file before running the macro doing the sort on the first 3 columns in order to...
I'm trying to modify a macro for transposing some data and it's not working. Here is the original macro:
Sub TransposeQandP()
Dim X As Long, Ar As Range
With Range("A1:A" & Cells(Rows.Count, "B").End(xlUp).Row).SpecialCells(xlBlanks)
For Each Ar In .Areas
For X = 1 To Ar.Count
Ar(1).Offset(-1...
Is there a way to do multiple independent sorts at the same time on the same sheet? I have data for multiple months in the same sheet and want to be able to sort them all at the same time but each sort should be independent of the others since they will all not have the same sales data in them.
What would be the best solution to format this information horizontally?
ItmItm AllQP
AK18025AK1802569
AK18025128.5
AK18025248
AK18025367.25
AB411FIRAB411FIR354
AB411FIR652
AB411FIR1250
AB411FIR2448
AE120AUSAE120AUS360
AE120AUS656.25
AE120AUS1253.13
AE120AUS2450
AY521AY5213169.75
AY5216162.5...
I'm trying to use the MID function on a string to be able to put all sections of data but the problem is that the starting point on each section throughout the document can be in different places and I want to be able to use a FIND within the MID to look for an occurrence of each separater(:) to...