Saturday, February 25, 2012

Pivot tables, Charts, Pivot chart

Hi all,

Can someone help me with some learning resources of Pivot Tables, Charts and Pivot Charts.

Thanx

Search for Pivot Table in Excel help you'll get some topics that explain these concepts and how to get started with them.

Here's one that came up that is online if you don't have Excel Help handy at the moment:

http://office.microsoft.com/training/training.aspx?AssetID=RC010136191033

Here are some more results to browse as well:

http://office.microsoft.com/en-us/results.aspx?Scope=DC%2CEM%2CES%2CFX%2CHA%2CHP%2CQZ%2CRC%2CTC%2CXT&Query=Pivot+Table

Hope that helps.

|||

Hello,

I am having issue with Performance of the Pivot Table connecting to OLAP Cubes. I am wondering if any of you have links to how to improve Pivot Table performance? Basically, I have done the backend optimization on the schema, but there should tricks on the Excel such as Connection Properties that I could use that could relate to MDX or Threshold Level that could speed up the Pivot Table performance. Below is some initial thoughts...

Non Empty Threshold=1

Any help is appreciated!

-Lawrence

No comments:

Post a Comment