How the fuck do pivot tables work
I tried to make one and it always fucks up as I don't have my dates in one colum..A..like they always go in pajeet YouTube videos
My dates go across the top a new column for each day reeeeeeeee
Im gonna shoot bill gates
Other urls found in this thread:
Try going a day without insulting a minority. Just try it.
nigger
Fuck off Russia bot
Can someone reprogram that bot to help me do my IT homework
They literally can't. Hey faggot, go on fiverr and get some pajeet to do your work for you, that's what your boss will be doing as soon as he figures out you're four times the price and can't even do pivot tables.
udemy curse
No I wont to learn not be a nigger
pivot tables are not too difficult. The issue is that you have to think in a different way then you usually do for excel. Can you send over the file or at least like a fake version with the same data headers? I am really good at excel and actually like using it. So I can try to help.
Hard to know what you're trying to do when you just bitch about your dates not going where you want...
You can have multiple categories in "row labels." If you right click and go into options there is a setting that says something like classic view or some shit (i can't remember off the top of my head), but it says something like it enables dragging of data or something like that. If you can't figure out how to do it from there then you're too stupid to be doing whatever you need it for anyway.
youtube.com
This is a white man explaining it. It helps you get the basics. If this guy for example wanted to break the numbers in this video down by the months they were sold in. You would make that a column and then it would allow you to see o in x division I sold y in march.
I have tried
I've read lots and watched videos but its always really basic situations, really simplified stuff.
Also the different terminology - I cant find the right terms so when I google it returns simple stuff
What Im trying to do is on Sheet 1 have a summary of lots of raw data on sheet 2
On sheet 1 I want to have a drop down list to select a date.
That date should correspond the dates which are headers in sheet 2, i.e Colum a 1st June, colum b 2nd june and so on
Then when I drop that on sheet 1, it pulls data from certain certins within that column on sheet 2 and returns it to about 10 different totals on sheet 1
So, based on who I listen to I should
- use a v lookup as a date selector
- use match (didnt find more info on this)
- use dynamic range
- use pivot tabels
when I try pivot tables it makes a mess of the dates. I select 30+ dates and it doesnt organise them into a drop down list and I have to tick them all 1 by 1 when Im playing around with where to place them
Have so much wrong information I dont know how to finish it
Thanks user I was watching this guys videos
but again he does things by all things being in one colum..my tabel runs the other way
i use cells for information and columns for dates, thats what hs me fucked
Do you mean like this?
Also, I respect you actually trying to learn. Better than other people who never learn.
Wouldn't he have to rotate the table so the dates were in a column for excel to the pivot it correctly? Trying to remember while laying in bed.
Wtf is this shit. Are we not on the most vile site on the fucking net? I can't fucking believe we've still got hipster faggot sjw's on this board.
exactly.
And I already have "total" worked out for each.
I already know my divison total as within divison, if I have 6 divisons, they are under it
So for example, B Column 1 Jun
B2 is my total
B3 - 1st Divison
B4 - 2nd Divison..
B8 - 6th Divison
B9 Products total
B10 - 1st Product
B11 - 2nd product
etc
Then back to Sheet 1 summary. I have so many of these values and totals running down my B column, I want to return a summary of the totals (and in some cases Total 1 + Total 2).
That all works fine within Sheet 2.
And on sheet 1 I have =values which call in my totals
NOW comes the problem. This is all manual work (with some macros)
I want a drop down in Sheet 1 which will automatically pick another date.
So move everything from B"" to C"" on this drop down click.
I can make the drop down using developer tools, but dont know how to call in that reference, and cant find the proper term to google it. Thats why Im so lost
Yeah, the options to do it if thats what he has is transpose it, which if he is considering using pivot tables, he probably has too much data to do that with. Secondly you could use vlookups I think to reorganize the data and then from the vlookups create a pivot table.
And to clarify - I know I prob could rotate my table and I almost did that..but
Having my dates laid out like this lets me asily see the daily trends. and have lots of values under that one day
rotating it makes no sense to me..unless im missing a better way to do it?
I can give a screenshot if that helps of the excel sheets?
Nah I get what you are saying. Just been a little while since I used vlookup. Trying to remember if that can solve your problem. And yeah I think it can, basically if you just vlookup a certain date it can fill all your other rows up with vlookups. Then all you do is make a list of the days and then drag the formulas down and it should fill all the columns with the info. From there you can run a pivot table so that if someone asks you what happened on jun 2 you can select that date on the pivot table and the data with show. Give me one second and I will give you an example. you may need to brush up on vlookup formulas though. because they can be confusing.
funnily im strong on vlookup.
I just thought that was the wrong way to do it.
...actually V lookup might not work as its column based too..hence it led me to match.
But it might be pivot isn't necessarily the answer in this case. or like you and user higher up said.
Tidy up my data using vlookup or formuals and run a clean pivot.
So you need your formulas to be based on the column of the date referenced in your drop down selection?
hmm do you mean like this:
Create a drop down (based on a new table)
And that drop down calls in formulas, which correspond to a date, i.e its not really calling in 1st Jun, its calling totals from B colum
Not sure if thats what you mean but maybe I understood a solution from it?
I realize why it wasn't making sense. There is a an Hlookup which is basically horizontal v lookup.
See example below. Make an hlookup for each row and boom your date is right way round, then you can pivot it. If you don't like that because of how it looks, think of it as just your raw data tab. Use the pivot to view data and your normal tab with the vertical date info for your daily stuff.
Also there may be a better way of doing this than a pivot table. And it has to do with table organization, but I literally haven't used that in 8 years so I can't say.
this also is using the table i posted before.
Re: pic, Be black, Qualifications wont matter you'll get hired
From that I can pivot and get the data with the dates on top as shown below. But like I said. This might not be the easiest way to present the data you are looking for.
ok - so I'll make another sheet - just for the pivot - and transpose all the data to a format whereby the information is the right way round.
Pain in the ass but seems it might work.
----also
I wonder if I can skip the pivot and simply use the hlookup to change all my cells in Sheet 1 to pull in the already totaled figures from Sheet 2.
cant believe this shit site improved my mental welbing for once rather than making it worse
...
Yeah like I said, without like totally understand with what you are dealing with. It is hard to say if this is the easiest way about it. But at least you learned how you have to present your data for it to work in a pivot table and I learned that Hlookup was a thing. cheers m8. I am out.
This website shocks people. Racism isn't shocking. If that's what you came here to do, leave.