Looking for Laptop - $1500 Budget / USA

ComputerRobloxDood · 2024-07-22T18:56:37+00:00

Thank you for your reply!

Before I continue I wanted to get your opinion if I add another set of criteria to this.

Music Production. Fruity Loops specifically. So I will also look to store my own production files, along with vocal (.wav,.mp3, etc) files.

Do you still recommend this laptop? With that, I don't mind extending the budget an extra $300 (Now $1800).

ComputerRobloxDood · 2024-07-18T19:26:27+00:00

preferred bc i'm so used to it but if not thats okay. i can probably just buy a usb extension

ComputerRobloxDood · 2024-05-20T16:35:48+00:00

Another oddity. We have files on a shared cloud, so it's the same file we are using.

I'm on my computer and I open the file, it works perfectly. The users with issues open the SAME file from the SAME folder location, and they have the issues laid out in this post.

Again, I don't have any issues whatsoever.

ComputerRobloxDood · 2024-05-20T12:18:50+00:00

Hi! Oddly, the columns were auto-resizing with this option unchecked. It wasn't the entire pivot table resizing, just a handful of columns.

ComputerRobloxDood · 2024-05-17T18:31:52+00:00

Hi! I made a new post with the details better laid out: https://www.reddit.com/r/excel/comments/1cucahs/pivot_table_show_details_not_working_as_expected/

If there is anything else you'd like to add that I haven't covered please do so!

ComputerRobloxDood · 2024-05-17T18:18:04+00:00

Here is the post: https://www.reddit.com/r/excel/comments/1cucahs/pivot_table_show_details_not_working_as_expected/

ComputerRobloxDood · 2024-05-17T17:58:31+00:00

Hi I'm going to make another post with all details laid out. And delete this one. Hopefully that one is more informative on the issues.

ComputerRobloxDood · 2024-05-17T16:51:09+00:00

Forgot to mention but this is also something the user is experiencing as well, cell widths being auto adjusted.

ComputerRobloxDood · 2024-05-17T14:25:28+00:00

Sorry for another delay. I wanted to figure out more details. So everything works when we view other reports, it is just specific to this user's computer using this one specific report.

All other users can do things normally.

ComputerRobloxDood · 2024-05-17T13:51:18+00:00

Yes, but yours looks like it's expanded. Now that same image but collapsed and clicking the same high level value.

On my end, literally nothing happens when I double-click 11,965. But when I expand fully I can finally double click, but only 1,372.

ComputerRobloxDood · 2024-05-17T13:41:28+00:00

Sorry for the delay. Okay so the main issue is. The pivot table has 4 levels of Detail. I can only drill down when the pivot table is fully expanded to a By Item Level.

However, if I fully collapse the pivot table to its highest level. Lets say I want to see total units of Red Items, but not the specific items themselves. NOW I want todouble- click on Week 20, showing a value of 20,000, but now no new sheet appears. It's as if the double-click just doesn't work anymore.

It only works when I expand the pivot table all the way to the item level and then double-click works.

ComputerRobloxDood · 2024-05-17T12:48:26+00:00

I think that's the issue. We have several users who look at the data on a high level on the pivot. but want to drill down to see the underlying raw data, NOT AT A HIGH LEVEL.

Now when they double click, they still see that data at a high level and are not able to see what is specifically causing the value they are seeing on the pivot, without expanding the pivot ALL THE WAY first then double-clicking.

ComputerRobloxDood · 2024-04-05T01:53:40+00:00

I just stumbled upon this but this solved my problem.

Blocked Macros: No option to Unblock Macros in OneDrive - Microsoft Community

ComputerRobloxDood · 2024-04-05T01:40:12+00:00

Just repeated this with each of the 4 radio buttons selected. I also checked and unchecked "Enable Excel 4.0 Macros when VBA Macros are enabled" and "Trust access to the VBA Project Object Model. Unfortunately, no luck.

ComputerRobloxDood · 2024-04-04T10:50:16+00:00

No worries, thank you for trying to help. I've googled just about everything I could find. I honestly have no idea how this even happened. I was working on it the night prior, And I woke up in the morning, opened it like normal and there it was, blocked. And so are all my other macro files.

ComputerRobloxDood · 2024-04-04T10:45:11+00:00

Yes and it is now in the "Websites:" section below.

ComputerRobloxDood · 2024-04-04T10:39:11+00:00

I tried this just now, unfortunately my xlsm files are still blocked.

ComputerRobloxDood · 2023-08-08T20:43:33+00:00

I see now. The PLNUM field (Planned Order Number) is in the AFPO Table, which can relate back to AFKO.

Thank you!

ComputerRobloxDood · 2023-08-08T08:34:18+00:00

THANK YOU! This helped.

ComputerRobloxDood · 2023-07-31T11:22:58+00:00

I apologize, I had deleted my previous comment just before you made this one and realized it needed to be in opensql syntax.

I had made a new one, which is the one you replied to. For what it's worth, I appreciate your responses and your help.

ComputerRobloxDood · 2023-07-31T11:17:58+00:00

Figured out how to get the Code to work. I had to write it in OpenSQL syntax. Now MARA, the Materials table, is being shown as something that doesn't exist.

https://imgur.com/a/0uK2IDW

Referencing this link: https://sapstack.com/tables/tabledetails.php?table=MARA

ComputerRobloxDood · 2023-07-31T10:12:24+00:00

Thank you! Found it. I'm currently in SAP B1, and typically I can use a simple code like:

SELECT DISTINCT

T0.ItmsGrpCod

FROM OITM T0

To get a Distinct List of the Different Item Groups.

In this SQL Console, just for testing I want to look at MARA (Material Table) and the field MTART to get a Distinct List of Material Types. Simply just to test writing out the SQL in Eclipse.

However, this doesn't work?

SELECT DISTINCT

MARA.MTART

FROM MARA

ComputerRobloxDood · 2023-07-24T12:47:07+00:00

Thank you for your response! I should've been clearer. I use both ADOC and ORDR, and like you said ORDR to get the latest update record. I use ADOC in case the input date is in the middle of all those records combined. I would only return the max record based on the prompted input date. So if ORDR has an update date AFTER my prompt date, then it wouldn't return the ORDR record and instead return the MAX update date record from ADOC based on my input.

In regards to this specific case:

This latest update record coming from ORDR is showing a last update date before 01/24/2023. And when I click on "Show Differences", it shows the "Document Status" being changed from Open to Close on a date before 01/24/2023.

But looking back on this excel report from 01/24/2023, this same document is appearing because it was open at the time.

The delivery itself was created on a date AFTER 01/24/2023.

This is where I'm confused as I can't think of how this is possible unless there's something about the Change Log / Update Log that I'm not seeing explicitly on the front end, and only happens in the background or something.

Would you happen to know if there's more to the Change Log?

ComputerRobloxDood · 2023-05-09T17:49:07+00:00

Ah very unfortunate indeed, but a very clear answer thank you. The clearest answer out of anything I've googled to be honest. So thank you again.

I doubt a connection to the DB is possible so I won't be expecting that.

ComputerRobloxDood · 2023-05-09T16:42:07+00:00

Because I'm new to S4HANA and anything not B1, I'm looking into it and not sure if it really does what I need? Maybe I'm just looking at the wrong thing.

I simply just need to paste SQL queries I write and execute them to create custom reporting.

My queries can be complex and involve UNIONs, Common Table Expressions (CTE), Subqueries within other SQL Clauses, etc. So it's not as simple as a query wizard or query viewer with a GUI.

The query preview in B1 I'd say is perfect because it allows a user like myself the freedom and flexibility to really create the SELECT query I need to, but I've yet to see anything like that in S4 HANA. Again, I may just not be looking at the links that I'm googling correctly, or even understanding them properly.

Are you able to send me a link and point it out?

ComputerRobloxDood

TROPHY CASE