Recent content by ahmed15

Hey everyone thanks for the help! I believe I was able to completely figure it out. Thank you for the assistance

AHAHA THAT IS SO FUNNY because that is exactly what I did but they don’t want that they want all 3 tables to reside in access... 😕 so basically they want me to copy and paste the pivot from table 1 into access. Somehow convert it into table 2 by mapping the values to the products and cost...

Take a look minty, this is basically the objective to achieve in access. Currently I just need to create the second table in access and copy and paste the first pivot

Pivot table 1: Channel (pivot filter) Transaction type(pivot filter) Product 1 Product 2 Product 3 Channel 1 Transaction type 1 X X X Transaction type 2 X X X Transaction type 3 X X X Getpivotdata Table 2: Cost Driver 1 (Mapped from channel + Transaction type +...

Aha thank you DBguy! Unfortunately it is not up to me I am a coop student at a bank and essentially they want me to create this as a mock for what i believe it should look like when they create it for a SQL server. They want to take raw data that is updated, insert it into a new table, then...

I am currently new to using MS Access with 0 experience. I have a pretty complex pivot table in excel with 28 columns and around 60 rows that feeds into another table where we use the Getpivotdata formula to pull data from the pivot into a new table which resides in excel. I want to recreate...