I have a data table with a bunch of transactions showing sales at various times over the past 2 years. I inserted a pivot table and summed up 2018 sales and 2019 sales. I created a calculated item to show year over year growth but it presents as $ along with the sum of the sales. If I change it...
This worked (the first one as you suggested). I don't understand what it's doing but I retyped it exactly as you had it and by gum, it worked! Thank you!
Hi everyone,
Is there a way to remove a middle initial from the end of a first name? I have data where the first name fields could be Nathanial J and then the last name field is Smith. Sometimes there's no middle initial there. Sometimes the first name is 2 names (e.g. Mary Anne) so I can't...
I don't think I have any new information, but are you able to explain to me *why* using a calculated item is not an option? What is it about this particular table that doesn't allow me to use it?
I can't do it from the original data because the original data shows Lead IDs as actual ID numbers. So it might be like 57676, 57677, 57678 and I needed the pivot table to count them so that in the pivot table the leads column will be 3. And the same with passengers...it might show 5 passengers...
Ah, no I didn't notice that. So you did another pivot table using the first pivot table as the data? When I try to add a calculated item I get a message "References to multiple item names per field cannot be included in the PivotTables formula", so it has to be a calculated field?
And is there...
1. How did you do that?
2. But those numbers don't seem to be correct. 11/87 should be 13% and that shows 20%. 4/35 should be 11% and that shows 0%....?
I'm not using powerpivot, just a regular simple pivot table. Here is a sample of the columns that would be a part of the calculated item, and a column that I manually calculated but am trying to create *as* the calculated item.
The original data shows a Lead ID number. The count of Lead IDs...
Hi there,
I have a pivot table with values to include count of leads and count of bookings. I want to have a calculated item that shows conversion rate, which would be ="count of bookings"/"count of leads" but the calculated item is greyed out.
How would I do this otherwise, and why is it...
I'm not sure if this is even possible, but I have a bunch of URLs in column A that all start with https://www.mycompany.com/businessline/salespeople and then end differently based on what page they land on. For example:
https://www.mycompany.com/businessline/salespeople/jsmith...
Ooh that's a great idea. I always think of pivot tables as only being part of larger long-term, ongoing spreadsheets...I forget they can be used for simple one-off tasks like this too. Thank you!
You know...I saw that solution in another post when I did a search but was positive I didn't have the same issue. Shame on me. Thank you very much...that was an easy fix.
Hi, this formula used to work on this report, but the last few months has been returning all zeros and I can't figure out why. (file attached)
I'm trying to say if the Fiscal Period is (x) and the agent is (y), what's the sum of sales? I see there are sales so I'm not sure why I'm getting all...
I have a bunch of cells that have absolute references. I want to copy those cells and change only the column part of the cell references (for example, the cell references are $A$1:$A$200 and I want to change them all to $N$1:$N$200). Is there a fast way to do that?
Does anyone know if there's a way to change just one label on the x-axis of a pivot chart?
And if so, how?
I have 6 labels going across the x-axis: Bob, Sam, Doug, Julia, Ava and Grace. I would like Doug's name to be in red while everyone else is in black, so that when Doug looks at it his...
It's not working correctly for me. On the list of domains filter, when I click to do the filter there's a little warning message on there that says "Not all items are showing" and when I click on that message it says "This field has more than 10,000 items. Only the first 10,000 items are...
I have a list of 255,000 email addresses. I need to pull 8% of each domain name and create a new list out from those. I can't figure out a way to make this process easier.
For example, I have 48,791 "yahoo.com" and I need to grab a random 3,903 of them; I have 536 "me.com" and I need to grab a...
Here's the sample. I highlighted the ones where there are multiples of the same customer number and the highlighted ones are the ones I would want, because they are the travel center for the most recent booking. So if I dedupe the customer numbers (P#), I want to then only show the recent one.
I know that title made no sense...sorry.
I have a spreadsheet that shows trips booked by customers. Customers are identified by a customer number and each trip shows trip number, customer number, booking date, and location. For each unique customer number, I want to show the location of the...