Hi All, I have workbook with multiple tabs and would like to use pivot table (or I am open to other options) to filter/sort the data. I have three tabs (Sheet1, Sheet2, Sheet3, etc). All three has following columns, First_Name, Last_Name, Org, and dates for for weeks (12/23/2017, 12/30/2017, 01/06/18, etc.). All three has same dates and First_Name, Last_Name, except for the values that are in dates rows.
I used insert table properties and used "Add data to the data model" option to use multiple tables/tabs. I used following link as guidance for this task but still stuck: https://computers.tutsplus.com/tutor...ets--cms-21190
I am unable to add dates/week-ending (12/23/2017) data from two different table into pivot table. I am getting following error: "We can't summarize this field with Sum because it's not a supported calculation for Text data types." (Both tabs has the rows set as "general" under number.)
What I am trying to achieve is use the user name and be able to get the delta between two tabs for different individuals.
I am open to whatever suggestions you may have. Thanks
Bookmarks