Imagen de Portada

Excel: A PIVOT TABLE WITH DATA FROM DIFFERENT WORKSHEETS

Guardado en:
Publicado en:Strategic Finance vol. 101, no. 8 (Feb 2020), p. 56
Autor principal: Jelen, Bill
Publicado:
Institute of Management Accountants
Materias:
Microsoft Corp
Names
Data models
Datasets
Servers
Acceso en línea:Citation/Abstract
Full Text
Full Text - PDF
Etiquetas: Agregar Etiqueta
Sin Etiquetas, Sea el primero en etiquetar este registro!
Resumen: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.
ISSN:1524-833X
0025-1690
Fuente:ABI/INFORM Global