Advertisement

07.16.2008 at 03:11PM PDT, ID: 23571512 | Points: 500
[x]
Attachment Details

Calculated Fields in Pivot Table Display #Name? after change to underlying SQL View

Asked by bminetwork2277 in Microsoft Excel Spreadsheet Software, SQL Server 2008

Tags: Microsoft, Office Excel, 2007, Pivot Tables

I am creating an Excel pivot table on a SQL view.  When I add calculated fields to the pivot table and then make changes to the view it sometimes starts displaying #Name? in the calculated fields.  What causes this to happen and are there any best practices to follow in modifying a SQL view without messing up all my calculated fields in a pivot table?Start Free Trial
 
Keywords: Calculated Fields in Pivot Table Display …
Title
1 Pivot SQL Table
2 pivot tables doing more complex calcul…
3 T-SQL Pivot Data
4 Viewing an Access 2002 Pivot Tabl…
5 SQL pivot to normalize?
6 Adding calculated field in a pivot table
 
Loading Advertisement...
 
[+][-]07.16.2008 at 07:01PM PDT, ID: 22021839

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.17.2008 at 03:29AM PDT, ID: 22023924

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.17.2008 at 02:04PM PDT, ID: 22030303

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.17.2008 at 06:36PM PDT, ID: 22032144

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.18.2008 at 09:05AM PDT, ID: 22037245

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.18.2008 at 09:30AM PDT, ID: 22037525

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.18.2008 at 08:04PM PDT, ID: 22041203

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628