![]() Textual data, such as Party, would appear in rows. For example, numeric data such as Precinct counts tend to appear to the right in columns. Right now I have a Calculated field with formula: correl(Volume,Price) However that field returns DIV/0 for every scenario, but if I double click to view the applicable data, I can manually do the correl() and it. Excel has logic that knows the field type and will try to place it in the correct row or column if you check the box. Ideally what I want is a pivot table that will correlate Volume and Price for a given combination of State, Cat.1, Year, and Month. He’ll walk you through some basics and also teach you some best practices. There are several ways to build a pivot table. Owen Duncan, Senior Content Developer for Power Pivot, will show you the ropes. Or maybe you’d like some tips on how to best work with a data model. But perhaps you’ve been struggling with it. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.Power Pivot lets you import massive amounts of data from different sources and mash it together to create useful reports.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |