for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers

GregP 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.
GlennR 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.
run free 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
run free 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?
logicscience 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.
run free 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"
GlennR 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.
run free 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 🤓
run free 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