Hey Excel Team,
I have a pivot table with 6 groupings for salary ranges by count of ID and displayed as % of grand total. Does anyone know how I can group the row grand total %? I’m trying to show the row grand totals by increments of 10% to identify the top 10%

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

Can you share a screenshot or an example of how you want it to look?

like

I got there in the end… if anyone runs into this I used three columns for individual % per row, cumulative % and percentile band to have both percentile and amount bands included in the pivot table I.e. Under 100K > 0-5% > 16% of employees.

Related Posts

What consulting firms are in Raleigh, NC ? And how is the pay compared to somewhere like Houston or Chicago?

like

How much should I expect salary wise from PGIM Fixed Income @27/hr as an intern and PWC FDD with 41/hr?

like

Which is better to join for long term...KPMG India or PwC India ? In terms of yearly growth, increment and bonus etc

like

Are there any disadvantages of joining a C2H role purely on the basis of high CTC even though it is for a big client of the contractor company?

like

Whats the variable pay range in Gartner?
And whats salary range for Analytics Manager (india)?
8 yoe

like

What are some good jobs for entry level in Charlotte that pay well for business marketing majors who are finishing up their MBA. The MBA is in business analytics and financial management.

like

Guys please suggest which company should i join
Optum(uhg) - 22 Lpa
IBM - 22 Lpa
Epam Anywhere - 24 lpa
YOE : 6.2yrs
~TIA

like

Europe!
What is reasonable salary growth coefficient when going from FTE to consultant?
My current reasoning is 2x as
* We get 100% parental leave for 6 months in current company
* Risk mitigation

I have never been a consultant before, what other factors should one consider?

like

What is the expected salary for Consultant position in Identity and Access Management field at Accenture?

Question for some of the senior partners on this bowl: do you mind sharing what does the the top end of partner comp look like? Is it like 2-3M annually? And how many years it took you to get there after becoming partner?

like

If anyone has insight on the compensation structure for the Managing Director/ Country CEO role I would appreciate insight on how package are structured and how best to determine the amount. Context is for a cloud tech consulting firm that is about 75M in revenue and 500 people and growing 10x on a 3 year intervals.

like
like

Need a sanity check here.

When I joined my current company, we were on a quarterly bonus structure with guaranteed payouts each quarter. This was, in fact, how the recruiter said he could meet my salary request.

The company just announced we are moving to annual payouts only, with no payments for 2023 until May 2024. There are no raises happening.

This amounts to 12% less money in my pocket in 2023 plus inflation.

Is this standard, or should I be looking for opportunities elsewhere?

like

Atos Will Apisero increase their offered package, if i have another offer letter of higher package when the joining is in just few days.

Apisero offer : 10.8 LPA
ATOS offer : around 14.5 LPA

Tech : Integration/Middleware tech developer role

Yoe: 5 years CCTC : 6 LPA
Suggestions welcomed on companies too.

If I jump to another big4 firm after 1 year, how much % raise should I expect?

like

B1 to B2 , how much hike will get in cg, eligibility criteria?

like

I have cleared both rounds for .net + azure and submitted required documents.
EOE - 10 YEARS
Current CTC - 15 lakh
current location - Gujarat
Have offer - 24.5

please help me to figure out What should be expected CTC i need to ask for
1) remote if they are providing ?
2) Pune location?

like

Can anyone please help me in the salary range for test lead in Coforge with 9 yrs experience…
Am awaiting HR round and this would really help., thank you

Can anyone tell me the salary range for a consulting associate at Huron? Strategy and operations. Huron.

like

More Posts

In order to DM i need 11 likes. Please help me guys

like

My boss has video on every single meeting. Status? On. IR? On. Not presenting and just there to chill? On. Even when no one else has it on and knowing it’ll just be his face taking up the whole screen. I’m starting to think he just likes to think we all love staring at him.

funnylikehelpful

Anyone looking for housing on the west side? I have a friend renting a house & she’s looking for a roommate (female) in WeHo. DM me for details if interested, thanks

like

I’m feeling anxiety about Coronavirus. Does anyone else think that the virus is being used by the government for population control? I don’t know if I’m paranoid.

like

McKinsey & Company Any experienced McKinsey casers interested in casing? Prepping for second round in Canada McKinsey & Company

like

Are warrants still available on IPOE? I'm having trouble finding the ticker on TD Ameritrade

like

If I resign from IBM , within 11months 15days what will happen?

like
like

Hi fellow creatives! I’m looking for any and all kinds of creative people to participate in a research study!

www.creativitystudy.com

I’m a creativity researcher working on my dissertation on the psychology & neuroscience of creativity. I’m interested in understanding how different types of creative careers, side hustles, and artistic outlets relate to our emotions, mental health, & well-being. Ultimately to help build awareness, resources, & improve the lives of creative people.

Please visit www.creativitystudy.com for more info!

Post Photo
like

What do y'all do in healthcare?

like

I did a buy/move/sale and for the 🏠 i bought I only put 16% and got a 2.875 rate with PMI. The plan was to pay the additional 4% after selling my prior home and get rid of pmi. I looked at refinance

like

Google stock to buy now or after the split?

like

Keep waking up at 4 am.. anyone have tips on how to avoid this and sleep thru the night? Generally go to bed around 1030 and wake up 630

like

Accenture ACN strategy and consulting Senior Analyst or consultant ? - For 4+ years of experience. Accenture

like

For University Recruiting, do you think it's helpful to write on my resume selective programs that I attended (like BCG Advance, PwC Women's Consulting Experience..etc) when applying to consulting firms? For example, would it be beneficial if I write in my resume that I attended BCG Advance when submitting an application for Bain?

like

I can't find a really interesting bowl here.

Does anyone know or be interested in an open-source bowl, for example?

Please suggest me good bowls 🙏

like

What are the working hours (approx) of BCG London? Is it true that WLB is ‘better’ in Northern Europe than Southern? (For example, Spain). And what would you say is/are the countries with the best WLB in MBB?

like

I have been seeing all of these "studies" saying that many people prefer working in the office versus working from home... I'm doubting these results and want to conduct my own little poll.
Do you prefer:
A) Working from Home
B) Working from the Office
C) Hybrid

likesmart

Currently renting for ~ $1500/mo in a low COL city. My lease ends in Dec and am looking to purchase a property and get into rental game. I have $40K in bank, but I’m not sure what my max investment should be or will be approved for. Would it be feasible to keep renting and also try to rent out a purchased rental property given my liquid cash?

like

Additional Posts in Excel Genius

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Hi there,
Which Excel courses you recommend for a beginner?

like

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

like

How do I compare two sheets to make sure they are identical?

like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

Hi excel geniuses, how do I quickly copy info from one cell to blanks for same if. Semi below I have products and names, for the blank fields w same product how do I quickly copy for the rest of the blank cells?

Post Photo

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

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

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

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!

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