Tupe77, yeah I appreciate the help. But while I understood your clarification, things like "misusing the forum" and "things I you can easily look up on the internet" come off like it's on purpose or out of laziness. What you said later on is correct, but you don't understood the details of how this project ended up in my lap and how it came to be that I built it up incorrectly from the start. And I do look things up on the internet all day every day. But when I need additional help in understanding something because it's either not working correctly for me or because I'm just having trouble grasping it, I turn to this forum of all-stars. I've been guilty of asking a question here & there that's an easy one to many people and easily found on the internet. But that doesn't mean that I just do that with everything. Hindsight is 20/20, and you don't know what you don't know... you know? And I didn't ask how to frame it up correctly early on, because It wasn't an issue.... until it became an issue. But then I solved that issue. But then another... but then that too was solved. But then they started getting worse and more plentiful, and then grew into major problems... and here I am. There were parts of the data that I didn't even have access to for a while, so I started building the shell of the project out based on what I was told, which turned out to be not even close to the truth. So yes, now I am in deep on a project that I would never have agreed to do had I known (A) the extent of it (B) the poor quality of their currect reporting, and (C) that it required me to do things that I did not know how to do at all. Like PQ for instance. Never used it before, never saw it... it was foreign to me. But backed into a corner, I stayed up for 2 dyas straight learning as much as I could about it, then I rearranged my project for that. Now however, I'm seeing that it needs to be arranged in a different way. But had I known that before... etc. But again, you don't know what you don't know. And also you learn the what to do's & what not to do's as you grow. I'm obviously not at you r level of expertise with Exce, but I'm sure that if you & I were in a recording studio then things might be reversed. You wouldn't know the best way to do it until you became experienced at doing it. I used to be all into Excel. But I'm a music producer now. A producer who has not been able to work on music for 2 weeks now because of this project that I thought would certainly be done by now. So I'm just on here very humbly asking for help from people who are way smarter than me with Excel. If anyone doesn't want to help me, then I respect that decision. I'm in the situation that I'm in for a myriad of reasons. I'm just trying to find a way to get back in front of it.
I'm sorry that you understood me completely wrong. I do not criticize you because you are asking here, but sorry because you're wasting your own time by asking the wrong questions.
I really don’t understand anything about how the studio works, but I know I won’t learn it from the equipment manuals. I’m also not a professional with Excel but just an enthusiast, so I know very well that I can’t know what I don’t know.
However, the biggest difference between us and top professionals like RoryA and Fluff is not the knowledge of formulas or VBA code, but their experience and understanding of the project as a whole.
(I know the difference is huge in coding too, so I'm not trying to downplay it)
You can easily learn to write code, but learning why you write it in code requires years or decades of experience.
I don’t know how much the professionals here are willing to spend their time helping, but I would recommend asking them about your project as a whole. You can get help from others us for formulas and other smaller things. I've been following your posts in the forum and I understand your situation as far what you've been told. Personally, I would need help in the implementation of the project you described and especially in the planning of the implementation.
I suggested you split your data into months or weeks, but RoryA immediately saw that you might not need that data at all because you could get the data directly from the connection. That's why it's worth asking them, because they would be able to tell you how to achieve your goal, and not how to do something...
I wish you luck with the project, but I hope you get help from some professional in planning, otherwise you will solve a huge number of problems that should not have been dealt with at all.
English is not my native lanquage, so if I write something very strange, it's probably because of it.
Power Pivot uses a language called DAX which has lots of built-in time intelligent functions for doing calculations like Year to date, Same period last year and so on. It is very powerful, but also therefore can be very complicated. 
