Recent content by Hayley

Oh my gosh...was it really *that* easy? That seemed to work. Thank you so much Excel Friend!!

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 guess I can! That worked! So this is saying from the right, take the length of the URL in A2 minus...? what's the "find" and "+11"?

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...