Can it work with numbers? I am trying to display numbers but there are multiple numbers for the same row. On selecting min or max, it only displays one of those and not all the values. It doesn't seem to work only for numbers which are repeated in other rows. Thanks Mike!
@glenbarrett5810
7 ай бұрын
When a number is stored as text, this does not work. Is uses the count function and you can't change that (unless anyone can show me how?).
@ledoopah
3 ай бұрын
Was there a solution found to display value stored as text?
@AAACrazy
2 ай бұрын
It doesn't allow me to pick anything else then Count, sorry, it didn't work.
@pandamonium9834
Жыл бұрын
Morning mikey nothing like a pivot table at breakfast time lol x🐼🐼
@IRLanthony
3 ай бұрын
Thank you! I typically do not have to present data, but now I do so showing those dates is important for me. I could not figure it out for the life of me to just show me the date and not a count.
@imscct
2 ай бұрын
what if the content is not date or number but a string of text
@maaty
19 күн бұрын
how to do pivot the % data in raw data column? it shows as count of or sum of
@MikeThomas67
19 күн бұрын
@maaty does this video help: kzitem.info/news/bejne/rZ-F0Kx9rHyhoKQ
@SarangManzoor
7 ай бұрын
is there any way to add two filters of same column in pivot table like i want to keep one day constant with a constant value and add data based on that day comparing with other days with data having same value as in data already filtered, but needed to compare with other days if someone asks me to compare cumulatively. i am able to get it done, but values of both adds up, which give wrong comparison. My data is arranged as in heading in columns (top to bottom, not left to right) as town name (karachi, Lahore), city name (Kot Lakhpat, South, area name (Alpha Mall, Hyperstar), Constant value (12345, 54321), and day (1: 12345, 2: 12345), and rest are values. if there is a way, please let me know by responding to me. It will be quite helpful.
@rj_lab
4 ай бұрын
What if the text value you want to appear is not a date value? For example 2 letter-initials from the sales man. *Example* Column C1 = RJ Column C2 = AB Column C3 = RU
@AtactHD
3 ай бұрын
This still only works for numbers though doesn't it? What if the value is text instead of a date?
@tsnmjnsr6742
6 ай бұрын
Thank you. This is helpful.
@shalonnehalstead1109
Жыл бұрын
Hi - I tried your method, but because my values are text instead of a calculable field, it doesn't seem to be working. I have users with associated user roles and accounts. I used the pivot table to sort all the users under their accounts and now want the column to the right to show the user roles, but it's just counting how many user roles (max of 1 possible per user) instead of showing the role the user has. Is there a method for this? Thanks!
@strongwithcurves
Жыл бұрын
I have this exact same issue and was really hoping to see a reply with an alternative technique. Did you find another resource?
@Dancimation
Жыл бұрын
I also have this issue. Anyone find an answer?
@MarkCsete96
Жыл бұрын
For this problem I found this video useful: kzitem.info/news/bejne/2Kmi1mZ4qnqmrW0 Pivot can only show numeric values, but you can create a rule to make numeric shown as text. It's kind of a work around, but it can work.
@azankamran6943
2 ай бұрын
Hi Sir, I need your help
@edwindeo
5 ай бұрын
Thanks bob
@dilipjethva4710
3 ай бұрын
very simply but effectively explained, thanks
@MikeThomas67
3 ай бұрын
You are welcome!
@sylens8266
6 ай бұрын
Thank you
@richardhainsworth9428
Жыл бұрын
Nice, simple little trick that is very useful. Thanks Mike
@tanayaug
10 ай бұрын
THANKS
@anachromancer7005
4 ай бұрын
This was incredibely helpful. Thank you for sharing it!
@graciasporverelvideo
Жыл бұрын
Thank you! It's very useful, you made my day
@MikeThomas67
Жыл бұрын
Glad to hear that!
@Sachismita
4 ай бұрын
How to show actual data if the values are Text?
@M-lr7uj
5 ай бұрын
What if i have the several dates for the same name and same training.
@elijahd.spragueph.d8905
8 ай бұрын
When I use this method for inserting times, it appears the pivot table automatically substitutes any blanks with 12:00 AM when I select the display MAX value. How do I get around this issue?
@MikeThomas67
8 ай бұрын
@elijahd.spragueph.d8905 Please drop me a message via theexceltrainer.co.uk/contact (I don't want to put my email address here)
@EcMcMuffin
5 ай бұрын
Is there a way to make that work, but with Text instead of a date? It doesnt work at my end unfortunately.
@MikeThomas67
5 ай бұрын
@EcMcMuffin I've been asked this a few times and I've not found a solution. If anyone else has feel free to contribute here!
@DiegoBahamonde-n6m
8 ай бұрын
Hi Mike, thanks for the this great explanation. I have a question: it is possible to do a PT using both, numeric data and dates, un the value column?
@MikeThomas67
8 ай бұрын
@user-pu1qd3st7d yes you can but you'd have to add them as separate items into the Values section. if you had a column in the source that contained numeric and date based data and added that to the Values section, Excel treats it as non numeric
@angelyeager9991
5 ай бұрын
Thank you for the tip. I just discovered the use of distinct count in my pivot table set up however when I did that all of my group totals went away, found the tip you shared her useful which helped re add those back into the pivot after using distinct value count.
@MikeThomas67
5 ай бұрын
Glad it helped!
@icameback1993
3 ай бұрын
Thank you so much
@jasmeenmuhammad8072
8 ай бұрын
Thank you Mike. Easy to understand and apply. Very useful. Just what I needed! Defiantly will be checking out other tutorials.
@MikeThomas67
8 ай бұрын
Very welcome!
@sachinkhurana1389
7 ай бұрын
thanks mike but how about the in time and out time in some data for some excel class students... as there are different sessions every hour... if i select max or min it show 1 session of the entire day... kindly help..
@MikeThomas67
7 ай бұрын
@sachinkhurana1389 Did you format the cells as Time? I'd need to see the data to provide more help. If you want to start a conversation please do so via theexceltrainer.co.uk/contact and I'm happy to reply
@sachinkhurana1389
7 ай бұрын
@@MikeThomas67 thanks Mike I will share you the data after discussing with you
@SleepyheadJJC
Жыл бұрын
Thanks Mike. Love the t-shirt 😊
@shemearivera197
4 ай бұрын
Really helped me a lot at this very moment! Thank you!
@MikeThomas67
4 ай бұрын
You're very welcome!
@somenathgayen3177
8 ай бұрын
HI Mike can we display time like the date is displayed if the data has time in it.
@MikeThomas67
7 ай бұрын
@somenathgayen3177 Try changing the format of the cells to Time where I set it to date in the video
@vijayarjunwadkar
Жыл бұрын
Thank you Mike for an easy to apply and very useful tip. I often get stuck in this, but your video made it so simple to follow and understand! 🙂
@MikeThomas67
Жыл бұрын
Great to hear!
@joaqimkhesser
2 ай бұрын
Thanks, Mike. Often when we looking for tricks like this it means it is rush hour, I always feel uneasy whenever I watch other videos and someone starts giving me stories "about how their great grand father fought in First World War, then next they say sponsor of this videos is, next they say subscribe!..like a bunch of unnecessary information"
Пікірлер: 51