Honest question - how can you read a pivot table that's not in classic layout? It's so much better than the default!

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

Agree 100%!!!

like

💯 I changed my default to classic/tabular. I have found some use cases for compact but it's rare and I've never found a need for outline.

I’ll never understand why we can’t change our default to classic view. I change it every single time.

Related Posts

What is up with greedy landlords/management raising rent by absurd amounts?? Just got my lease renewal and the rent hike is $1400 per month. Why does NYC not do more to protect us from this kind of predatory behavior?

likefunny

Dumb question, but I’ve never rented an apartment with a broker’s fee before - is it always 15% of a year’s rent or is that just the max?

like

Hi all,
I just moved here so this might be a dumb question so please don’t judge. Why does my laundry smell like pee and how can I fix it? I used a common washer and dryer in my building. Is it because of that? Is it mold? Is it the water? I air dry my workout leggings and they all smell really weird and I don’t know what to do 😔

like

Salary range of SM in Consulting (Finance & Insurance) in Toronto?

How much Siemens healthineer can pays to 3 years of experience with 4.5 ctc?

I’m a true night-owl that begins thinking clearly about 5 PM. I often send projects out after midnight. Early morning emails and calls are an adventure. Has anyone else had to work through this issue? Fight it or embrace it?

like

Hello! Looking at an opportunity with established startup in UK that's just been acquired by a large co. I'm US based and my salary is around $250k (NYC) -I've been asked my expectation without the startup giving me a range to work from (though I've asked). I'm not sure how to reply to them because I have a feeling that my requirement may be out of their range and while I don't want to undercut my value, I also don't want to be cut out of the process because it's an interesting co. Any advice?

like

How's the data science team in Gurgaon? Any insights, anyone?

like

Rewatching Brokeback Mountain, which came out 15 years ago (hard to believe that). Anyway, it's still an outstanding, devastating film (and love story) that I think if had been released 10 years later would have easily won best picture and best actor for Heath Ledger.

like

Best tacos in SD? I'm all ears

like

How long do you let your wine decant before drinking/serving?

like

Is there any profile which is based on purely SQL and nothing else, no excel/tableau/powerbi task.

like

Can someone share the salary for a UX designer with 5 years of experience in Microsoft. I have cleared all rounds and I am not sure what do I ask as my expected salary going by microsoft standards

like

Is anyone concerned the push for sexual equality in pay without accordant leveling of parental leave is gonna backfire?

Here’s a hypothetical:

A company has 2 candidates, aged 25-30, equal in every respect save one’s a man the other’s a woman. Maybe the woman is a slightly better candidate overall. They’d have equal comp.

Company considers the woman a riskier bet due to possibility she’ll take maternity leave — and considers the man less risky for his ineligibility to take as much leave. 🤷

likefunny

EY is hiring in Strategy and transactions, if anyone interested DM me.

like

Can someone refer one of my friend at Genpact Uppal Hyderabad??
Profile : senior recruiter.
Exp : 6.5

like

Holiday greetings from leadership be like

Post Photo
likefunnysmart

Hello Fishes

Recently i was scheduled for an EY GDS interview on 5th of November but no one showed up and interview did not take place , what is it mean?

Anyone else feel the customer service at W hotels is really bad?

like

Additional Posts in Excel Genius

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

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

Scan your QR code to download
Fishbowl app on your mobile

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