Hi ,
It looks like you're using an ad blocker.



The revenue generated from the adverts on the site is a critical part of our funding - and it's because of these ads that I can offer the site for free. But using the site for free AND blocking the ads doesn't feel like a great thing to do, which is why this box is so large and inconvenient. Some sites will completely block your access, but I'm not doing that - I'm appealing to your good nature instead. Did you know that you can allow ads for specific sites, whilst still blocking them on others?

Thanks,
Ian Williams aka Fetch
or for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers
Nov 2019
6:18am, 6 Nov 2019
115,944 posts
  • Quote
  • Pin
GregP
Ooh - I have an issue, Loggers-Sciers. Drives me nuts that I can’t easily put medians into a pivot table. Apart from that agree though.
Nov 2019
10:04am, 6 Nov 2019
46,088 posts
  • Quote
  • Pin
GlennR
Don't get me started on pivot tables. Learn to bloody code...

~awaits the arrival of the avenging valkyrie that is RunFree~
SPR
Nov 2019
10:05am, 6 Nov 2019
29,634 posts
  • Quote
  • Pin
SPR
Thanks logicscience.
Nov 2019
11:07am, 6 Nov 2019
3,618 posts
  • Quote
  • Pin
run free
Hahaha Glenn / Greg - you should be using Power Pivots. Greg you'd be able to do exactly what you've said :p
Nov 2019
11:12am, 6 Nov 2019
3,619 posts
  • Quote
  • Pin
run free
Logic - has does expansion of a cell in pivot table analysis drop columns?
Nov 2019
12:35pm, 6 Nov 2019
48 posts
  • Quote
  • Pin
logicscience
Run free : it does if there are ‘too many’ columns in the original table that is the pivot source. Then when you try and transform a cell back into rows that created the measure columns are lost.

Is power pivots not the only way to put a median in?

‘Add to the data model’ was a revelation for me to achieve distinct counts.

Kinda agree with GlennR about coding. Learn to code faster than a few sweeps with the mouse is perhaps appropriate.
Nov 2019
2:27pm, 6 Nov 2019
3,620 posts
  • Quote
  • Pin
run free
Logic - haven't had that issue yet so probably would need an example to see what's going on. Power Pivots is the way forward. And your measures should be developed as a measure and not simply another column. You'll have to come on a course with me ;)

For the median you could use Cube Functions as well, but it is still referring to OLAP (analysis services / Power Pivot) to enable. Sounds like you've been using Power Pivot anyhoo .... i.e. "Add to the Data Model"
Nov 2019
6:09pm, 6 Nov 2019
46,115 posts
  • Quote
  • Pin
GlennR
Bloody hell, it’s all gone potato prints and fuzzy felt round here. ;)
Nov 2019
6:48pm, 6 Nov 2019
3,621 posts
  • Quote
  • Pin
run free
You should try the cactus ice cream, or tomato and basil flavour ..... very interesting 🤓
Nov 2019
6:51pm, 6 Nov 2019
3,622 posts
  • Quote
  • Pin
run free
Logic - to create a measure you can use the Power Pivot tab or go into the Power Pivot interface. Dragging a column into the values section of a PivotTable ain’t the best way

About This Thread

Maintained by John66
This is bugging me, I'm sure it should be much easier

A1 has 25/6/2010
B1 has 24/6/2013

So t...
  • Show full description...

Related Threads

  • excel
  • support
  • tech
  • work

Report This Content

You can report any content you believe to be unsafe. Please let me know why you believe this content is unsafe by choosing a category below.



Thank you for your report. The content will be assessed as soon as possible.










Back To Top

Tag A User

To tag a user, start typing their name here:
X

Free training & racing tools for runners, cyclists, swimmers & walkers.

Fetcheveryone lets you analyse your training, find races, plot routes, chat in our forum, get advice, play games - and more! Nothing is behind a paywall, and it'll stay that way thanks to our awesome community!
Get Started
Click here to join 114,497 Fetchies!
Already a Fetchie? Sign in here