How do I use formulas that reference a pivot table without copying and pasting the pivot as values?

Posting as :
works at
You are currently posting as works at

Or select the option to turn off the getpivotdata formula.

likesmarthelpful

Click on the pivot table. Click the analyze tab.... me too!

like

Type the cell references in manually will work on a lot of cases

likehelpful

Bingo

Or rebuild the pivot with formulas

like

Related Posts

Post Gif

Hi fishes,
Need 11 likes to activate DM.
Thanks in advance. 🥹🙏🏻

like

Welcome to the wild and weird world of Chicago

like

How to evaluate 0.01% ownership of a startup? Let’s say their “equity component” is 0.01 of a series B ($130M funding) startup, then that’s $100k even if their valuation is $1B. For my equity to be worth anything, what it’ll take is for the series B startup to grow to $10B valuation and actually able to fetch that valuation in an IPO (so it’s not just over-valued private stock). Even Notion is just $10B valuation and probably overvalued. So, isn’t this 0.01% ownership thing ridiculous?

likehelpful

Obviously I know that health care workers hv more important work to do now etc etc, but if I am asked to do a medical checkup around this time, what are my options in NYC?

like

Any recommendations on the platform you use for options trading? Looking at the ones that have the best tools. I was thinking between TD, Etrade & tastyworks.

like

What is the difference between roles as a Senior AML Consultant vs. Senior Analyst Global Anticorruption and Financial Crime Compliance? Considering applying.

Raytheon Technologies Corporation what is employee retention rate?

like

Hello All!

I am a graduate of Suffolk University, and I recently received my masters in Business Analytics. I am currently pursuing a career as an IT Business Analyst at MSU Denver, which I have the 30min first round interview scheduled for Tuesday, November 29th.

If anyone is or was previously employed as an analyst at MSU Denver, would you mind providing some insight into the culture, the interview process, salary information, etc. I would truly appreciate any help as this is a role I want

like

I adore this baby!

Post Photo
like

Hi All, How is the career growth in Clinical Data Management field. How much pckg generally company pays in this field.
Location Pune
Exp 7

like

Hi Fishes,

Need some suggestions. I gave interview on Tuesday, will it be right to ask feedback tomorrow or should I wait till the end of week and then ask for feedback on Monday Morning. Today, I didn't got any response from them.

like

Hi guys.

For IT proof submission, after the 12BB is generated, there is no option to upload signed 12BB form in the portal. Where to do that?

like

I just accepted an offer as Creative Director/Art at a small shop. What are some of your favorite books on being a great CD / manager / creative leader / mentor? Where can I get practical tips that will help me on the job?

like

Hey Folks, i joined yesterday - Optum Noida, how long will it take to get Sez and Id card? Till then what needs to be done?

Anyone have any insight into MERGE? I see some openings

like

Hi All, I’m new to the app and could use some likes to unlock more features thx!

likeupliftingsmarthelpful

Was just told I’ll be making just over 200k TC at EOY promotion. Position has a lot of upward mobility potential in coming years. I’ve been here a few years with consistent high ratings. However, I’m concerned I may not be learning as much as I could. Plus, I may find similar or higher pay elsewhere. Any tips for evaluating? I’ll be 27 at promo.

funnylike

Hi fishes, I am actively looking out for UI /frontend opportunities. Saw a post saying Microsoft is actively hiring. Will someone be kind enough to refer me for the same. YOE: 7 years
Microsoft

like

Additional Posts in Excel Genius

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

There has to be a way to restrict access on a worksheet so that only specific cells can be edited.

No matter how many times I’ve tried to automate and simplify generating reports to just inputting data into specific highlighted boxes, someone just have to try to edit a completely different cell then asking why the worksheet is “broken.”

likefunny

Hi, two of my colleagues keep getting a run-time error 91 when trying to run a macro on this worksheet. However, I am unable to detect the issue nor find a solution as this does not happen to me when trying to run the same macro. Any way I can find a solution?

like

Has anyone gone through Elevate Excel by Excel Campus? Looking for reviews as I'm having trouble finding any that aren't on their website....

like

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

*** This is a public announcement ***

PLEASE stop hiding rows and columns and start grouping them instead

— yours, the person who is trying to understand your work

likefunnysmart

Hey guys, I have a Google spreadsheet where each cell has multiple links separated by semi-colons.

How would you get the links to show up in different rows WITHIN a cell? (Pictured is what I want to achieve).

Thank you so much🙏

Post Photo
like

I have a spreadsheet that includes these columns: total AUM of firm X, % of AUM allocated by X to sector Y, % to sector Z, and so on (one column for each sector). Goal is to present in tabular form...

Does anyone know how to reformat a date from yyyy-mm-day to month-day—yyyy?

like

Anyone have recommendations for good hands on courses to increase proficiency in excel? I want to learn how to do vlookups better and use if/then statements and manipulate large sets of data to create dashboards. I know YouTube but I’m asking for courses that I could put down for development as part of my performance review.

like

Hello Everyone,
I would like to create a schedule for all of my clients. Let’s say I have platinum, gold clients etc. What would be the best way for me to schedule a call for them based on their profile of gold or platinum? For example, I would start scheduling a call every month for my top clients, then a call every quarter for other categories… I need to track the data, and make sure employees are calling them… something that would alert my employees to call such clients. Thanks!

like

Looking to set up conditional formatting to indent a cell if another cell has a certain number of characters. Please see comments for details.

Post Photo
like

Does anyone here use ASAP Utilites as an Excel add-in? This thing is amazing.

like

My Goal: I have a drop down menu in a cell. I want it to sort conditionally based on what I select. Is that possible?
Ex: If the drop down ="done" it falls to the bottom of the list.

like

Help, simple task can’t figure it or. List of user names in one sheet compare to another list on another sheet and highlight duplicates.

like

Please help: 2 line items of data is getting dropped from the source to the pivot table. The source is an excel sheet in the same workbook so I can quickly verify that the data is there. Now I’m getting REF results from my GETPIVOTDATA formulas. How do I begin to troubleshoot this?

How can I make these dates sortable with a filter?

Post Photo
like

Is there an absolute moron’s guide to Index Match? I have two tables of users, some exist on table A that don’t on B, and vice versa. I need to merge them based on their email as the unique identifier

like

What are the most typical models you all build

likehelpful

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal