Thanks to Diego Oppenheimer for putting together this post. When thinking of Excel as an OLAP analytical tool the first thing that usually comes to mind is the ability to quickly and easily analyze data from an OLAP data source. With the introduction of PivotTable What-If Analysis in Excel 2010 you can now easily modify this data as well. Put simply, PivotTable What-If Analysis is the ability to modify values in PivotTable cells, recalculate the PivotTable with those values and, if the results are
Read More...
Read the complete post at http://blogs.msdn.com/excel/archive/2009/10/12/excel-2010-pivottable-what-if-analysis.aspx
Posted
Oct 12 2009, 04:34 PM
by
Microsoft Excel