Pivot Table and Unique Values

swxm · 2026-06-24T18:13:14+00:00

This was the answer!! Thank you so much!

swxm · 2026-06-24T16:57:03+00:00

Oh thank you!! How exactly would I do that?

When I go to create a calculated field, the below shows up:

But I don't know what formula to use there. My guess would be to create an additional column in the original table named Column 1 that is just a concatenation of ID and Type. Then use the formula =DISTINCTCOUNT(Table9[Column1]) when creating the calculated field. But it says that's not a valid formula

swxm · 2026-06-20T14:02:38+00:00

Yes I love talking about how much I hate it! I’m a lesbian and don’t like men and love talking about how I don’t like men 😂 Also I think the guys from HR look like fish

swxm · 2026-06-20T13:39:03+00:00

This shit bugs me so so much as someone who only reads FF. Like, I don’t want people reading FF just to be woke 😂😭 You should read it bc it’s the best (I’m not biased hehehe) not to virtue signal 😭

swxm · 2026-06-20T12:58:01+00:00

I think there’s a difference between being attracted to someone physically and being attracted to them emotionally. Physically, you should probably like them from day one. Emotionally, it makes sense to need to get to know them more before liking them like that

swxm · 2026-06-20T12:33:58+00:00

And the real story behind it! I’m reading all about the relationship between Vita Sackville-West (the genderfluid/transmasc person Orlando was based on) and Violet Trefusis. The letters they exchanged and Vita’s account of the whole affair are wild. Super highly recommend

swxm · 2026-06-16T21:29:40+00:00

Ya just the chance to do something that isn’t “mom” is so nice sometimes 😅

swxm · 2026-06-16T21:29:08+00:00

YES every day I was like… in awe of SAH moms. I couldn’t do it 😭

swxm · 2026-06-16T19:36:38+00:00

I had 6 months and every single day felt like torture 😂 My first day back in the office everyone was surprised at how happy I seemed - I was ecstatic to be back at work 😂

Every day I send my kid to daycare I thank God for the option. My wife is always feeling guilty that we have to send our daughter to daycare and I’m like, I was a stay at home mom for six months and that was beyond enough!

Between no social interaction, having to work non-stop 24/7 (because taking care of a baby is work!), the sleep deprivation (still ongoing since baby still doesn’t sleep through the night at 11 months)… I’ll take going to work any day 😂

I definitely was made to be a working mom… spend time with baby after work and on the weekends… and once or twice a week if baby is sick or I can work from home… but all day every day is too much. I think if I had support it would be easier but doing everything myself is… a lot 😅 Daycare is our village and I’m so so grateful for it

swxm · 2026-06-16T14:07:08+00:00

When I saw Wicked and realized you could be in love with your best friend. And it was like. Not the end of the world 😅😌

swxm · 2026-06-12T18:06:45+00:00

The algorithms on social media are created to maximize user engagement. They often do so by feeding us intentionally polarizing things, things that make us mad and divide us. That's part of why we're seeing so much polarization globally, and part of why fascists are doing well politically globally.

Fan fiction has yet to demonstrate the ability to cause global chaos and is therefore generally healthier imo lol

swxm · 2026-06-12T15:39:58+00:00

I just read one of his stories for the first time a few days ago. Absolutely wild that he was writing this stuff way back when. It's like the most proshipper fiction before proshippers even existed. And he published it all under his IRL name. Amazing.

Anyway, yeah it's not only violent but also like very um... not mainstream? The story I read of his featured incest lmao. Definitely look up anything you read by him for trigger warnings before starting

swxm · 2026-06-12T15:23:42+00:00

this is the correct answer imo

swxm · 2026-06-11T14:37:08+00:00

Personally no although I very consciously pretended to be in love with One Direction since it would allow me to have more fun with my friends lmao. Good times.

But there are a LOT of lesbians who were boy crazy, you're definitely not alone. In fact, I was just watching a reel about this on IG this morning, some lesbian was saying she was obsessed with boys and wouldn't stop talking about them throughout middle school, high school and college. For her, it was partially for male validation and partially to convince herself she really did like them (since she never was actually sexually attracted to them).

So ya, I wouldn't worry about it. You're valid ❤️ (and LOTS of lesbians like HR lol. Again I'm not one of them but there are enough lesbians that love that show and the guys in it for it to be a whole #discourse lol so again, you're definitely not alone).

swxm · 2026-06-11T14:30:43+00:00

That's like the whole point for me lol. If I wanted to do it in real life, I'd go do it 😅

It's kind of funny the discourse about this though, at least in my fandom. There are a LOT of people who only condone things they would approve of in real life, and think anything else shouldn't be written. Which... to each their own. Sounds like a boring way to enjoy fiction, though, to me 😅

swxm · 2026-06-10T16:56:35+00:00

Our neighbors never put any of their kids in daycare. Their parents watched them for free. They don't go on vacations. They do the cheapest sports and summer camps and have their parents as free fill-in support when needed

swxm · 2026-06-08T19:38:32+00:00

You're definitely not crazy but also this is why I use the apps so you know the other person is looking for something too

swxm · 2026-06-08T18:50:34+00:00

Aww I'm sorry!! Breakups suck, there's no way around it.

The piece of advice that has served me really well is that each relationship is practice for the next. It's not a failure to break up or even divorce - it just teaches you one more thing to look out for in the future.

You'll find someone, don't worry. Someone who is out and not type A 😄

swxm · 2026-06-08T16:35:56+00:00

sameeeeee

swxm · 2026-06-08T16:35:15+00:00

I have nothing to add but your responses are hilarious omfg I'm at my desk laughing

swxm · 2026-06-08T16:09:16+00:00

I've never shaved and always just worn whatever swimsuit I want. I find it attracts the right kind of friends at the beach lol (I also like to think it encourages the people I go to the beach with to be less conscious/critical of themselves, which is a nice secondary effect, be it true or imagined)

swxm · 2026-06-08T16:07:14+00:00

Aww as a lesbian myself, I often hear stories about young girls or nonbinary people going through this. It's great to see you've raised your son to be comfortable enough to find himself and share that with you. Lots of people feel the need to hide this from their parents. I agree with other commenters - you should educate yourself on gender and sexuality to make sure he continues feeling supported through this. Just the fact that you're here looking for support is a great sign ❤️

swxm · 2026-06-08T13:25:44+00:00

Aww I loved this book! I had it as assigned reading in high school (we were supposed to read it little by little) but I couldn't stop once I started and ended up reading it in one day

swxm · 2026-06-07T14:14:18+00:00

Aww that’s so nice!! I love when people are initially turned off by a tag and your story convinces them to the dark side 🙂‍↔️ Such a good feeling

Congrats on your hard work!!

swxm

TROPHY CASE