I will send you another sample WS that has a sample of a third WS "Game" It only has one index column marked Game ID. Each entry into that column is unique and relevant to columns in both the Pitching WS as well as the Play by Play WS.
Your explanation would imply that the Game WS could be set up in one Olap table with the Pitching and a separate Olap table with the Play by Play WS. But you cannot work the Pitching and Play by Play WS's together as neither has a unique column. The index columns in the Pitching and Play by Play columns would have to be reformatted, or a fourth column added, to allow one relational Pivot Table for all three WS's.
These two lines imply that the 2016 Data Model has different and more powerful properties than the OLAP table, including the retrieval of individual records. I've seen tutorials that allude to them as Power Pivot and Power Query.
"In addition, it's important to remember that pivot tables have a specific purpose: to summarize data. They are not intended to be used as query tools to return individual records.
However, Excel 2016 introduces the Data Model and Get & Transform tools that allow you to query your data. You might want to investigate these as opposed to OLAP pivot tables."
Are these the tools you are talking about
Game Sheet Pitching and Play by Play example 2-6.xlsx 24.84KB