Content area

Abstract

Translate

Microsoft will join the data from the three tables much like a query in Access or SQL Server. A pivot table created from external data is treated as an OLAP pivot table, and a number of pivot-table features only work with OLAP pivot tables. Joining worksheets in the Data Model brings the relational power of Access or SQL Server to Excel.

Details

10000008
Subject
Names;
Data models;
Datasets;
Servers
Company / organization
Name:
Microsoft Corp
NAICS:
334610, 513210
Title
Excel: A PIVOT TABLE WITH DATA FROM DIFFERENT WORKSHEETS
Author
Jelen, Bill
Publication title
Strategic Finance; Montvale
Volume
101
Issue
8
Pages
56-57
Publication year
2020
Publication date
Feb 2020
Section
Technology WORKBOOK
Publisher
Institute of Management Accountants
Place of publication
Montvale
Country of publication
United States
Publication subject
Business And Economics--Accounting
ISSN
1524833X
Source type
Scholarly Journal
Language of publication
English
Document type
Journal Article
ProQuest document ID
2354877095
Document URL
https://www.proquest.com/scholarly-journals/excel-pivot-table-with-data-different-worksheets/docview/2354877095/se-2?accountid=208611
Copyright
Copyright Institute of Management Accountants Feb 2020
Last updated
2024-11-21
Database
ProQuest One Academic