Excellent video and super helpful! Simple, precise and easy to understand. Thank you Excel Master for your quick replies and help when I stumbled on solving my pivot table relationship error!
Hover the second set of tables is not dynamic as you copied and then configurated as a table too. Means if your information in first set of pivot tables changes it won't update the last pivot table.
I've 2 tables that are fed from Salesforce - both are identical as I'm unable to extract more than 2000 columns from Salesforce. The overall data I need to extract is 2600 columns. I get the error message that both tables are similar, unable to proceed. Is there a work around to merge/connect both tables with similar date?
I have a sheet of data in multiple columns with staff name and working hours for Monday to Sunday, im unable to do pivot table Row (staff), Column(week) and Value(hours)
I have two unique columns i cant combine them. The message says 'Both selected columns contain dupkicate values. At least one of the coulmns selectes must contai unique values to ctreate a relationship between the tables'. Do you know why and how to fix it? the unique column is gorup numbers.😊
I know I’m not the only one who hates the music at the background. Why don’t you just talk through the tutorial instead?? Keep explaining the steps so we can understand better
No video ... Just create a single "structured" table with a column for sales and a separate column for Purchase. Then just do a normal pivot table and use two value columns.