When a new calculated field 'calcfield' is created, a 'SIGMA values' is
added to the column-labels-area, and a 'sum of 'calcfield' is added to
the values-area.

But I want to use the new field in the row-labels-area, and it is
impossible to move the new field to that destination.


When I read books about Pivot tables for Excel 2003, it looks like the
calculated fields should behave like other fields in this respect.


Do I see over some checkmark?

When you create a calculated field in Excel 2003, it can only be placed
in the data area.

If there are multiple data fields, you can view them horizontally, or
vertically. To change the orientation, drag the Data button into the
column area or row area.

Gert Kok wrote:
> When a new calculated field 'calcfield' is created, a 'SIGMA values' is
> added to the column-labels-area, and a 'sum of 'calcfield' is added to
> the values-area.
>
> But I want to use the new field in the row-labels-area, and it is
> impossible to move the new field to that destination.
>
>
> When I read books about Pivot tables for Excel 2003, it looks like the
> calculated fields should behave like other fields in this respect.
>
>
> Do I see over some checkmark?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

So when variables are needed to group data based on a calculation based
on a date (like weeknum, month, workingday, weekend etc) those should
be located as formulas in the original data-table?

What is then a good way to replace the 'hard' data while keeping
formulas and a references intact?

I tried some solutions but one time the links were broken, another time
I couldn't use import into the table.

Gert Kok

Debra Dalgleish wrote:
> When you create a calculated field in Excel 2003, it can only be placed
> in the data area.
>
> If there are multiple data fields, you can view them horizontally, or
> vertically. To change the orientation, drag the Data button into the
> column area or row area.
>
> Gert Kok wrote:
>> When a new calculated field 'calcfield' is created, a 'SIGMA values'
>> is added to the column-labels-area, and a 'sum of 'calcfield' is added
>> to the values-area.
>>
>> But I want to use the new field in the row-labels-area, and it is
>> impossible to move the new field to that destination.
>>
>>
>> When I read books about Pivot tables for Excel 2003, it looks like the
>> calculated fields should behave like other fields in this respect.
>>
>>
>> Do I see over some checkmark?
>
>

So when I want to group data on a calculation on a date (like weeknum,
month, workingday, weekend etc) , I need variables who should be
located as formulas in the original data-table?

What is then a good way to replace the 'hard' data while keeping
formulas and a references intact?

I tried some solutions but one time the links were broken, another time
I couldn't use import into the table.

Gert Kok

Debra Dalgleish wrote:
> When you create a calculated field in Excel 2003, it can only be placed
> in the data area.
>
> If there are multiple data fields, you can view them horizontally, or
> vertically. To change the orientation, drag the Data button into the
> column area or row area.
>
> Gert Kok wrote:
>> When a new calculated field 'calcfield' is created, a 'SIGMA values'
>> is added to the column-labels-area, and a 'sum of 'calcfield' is added
>> to the values-area.
>>
>> But I want to use the new field in the row-labels-area, and it is
>> impossible to move the new field to that destination.
>>
>>
>> When I read books about Pivot tables for Excel 2003, it looks like the
>> calculated fields should behave like other fields in this respect.
>>
>>
>> Do I see over some checkmark?
>
>

Weeknum, working days and weekends could be calculated in the source
data. Month could be created by grouping dates in the pivot table.

I don't understand the rest of your question.

Gert Kok wrote:
> So when variables are needed to group data based on a calculation based
> on a date (like weeknum, month, workingday, weekend etc) those should
> be located as formulas in the original data-table?
>
> What is then a good way to replace the 'hard' data while keeping
> formulas and a references intact?
>
> I tried some solutions but one time the links were broken, another time
> I couldn't use import into the table.
>
> Gert Kok
>
> Debra Dalgleish wrote:
>
>> When you create a calculated field in Excel 2003, it can only be
>> placed in the data area.
>>
>> If there are multiple data fields, you can view them horizontally, or
>> vertically. To change the orientation, drag the Data button into the
>> column area or row area.
>>
>> Gert Kok wrote:
>>
>>> When a new calculated field 'calcfield' is created, a 'SIGMA values'
>>> is added to the column-labels-area, and a 'sum of 'calcfield' is
>>> added to the values-area.
>>>
>>> But I want to use the new field in the row-labels-area, and it is
>>> impossible to move the new field to that destination.
>>>
>>>
>>> When I read books about Pivot tables for Excel 2003, it looks like
>>> the calculated fields should behave like other fields in this respect.
>>>
>>>
>>> Do I see over some checkmark?
>>
>>
>>
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

The problem was how to refresh the 'real' data, while keeping the cells
with formulas synchronised, whether there were more or less new data
rows in a new dataset. Of course that's why the 'refresh' command was
invented for tables...

Thank you for the tips

Debra Dalgleish wrote:
> Weeknum, working days and weekends could be calculated in the source
> data. Month could be created by grouping dates in the pivot table.
>
> I don't understand the rest of your question.
>
> Gert Kok wrote:
>> So when variables are needed to group data based on a calculation
>> based on a date (like weeknum, month, workingday, weekend etc) those
>> should
>> be located as formulas in the original data-table?
>>
>> What is then a good way to replace the 'hard' data while keeping
>> formulas and a references intact?
>>
>> I tried some solutions but one time the links were broken, another time
>> I couldn't use import into the table.
>>
>> Gert Kok
>>
>> Debra Dalgleish wrote:
>>
>>> When you create a calculated field in Excel 2003, it can only be
>>> placed in the data area.
>>>
>>> If there are multiple data fields, you can view them horizontally, or
>>> vertically. To change the orientation, drag the Data button into the
>>> column area or row area.
>>>
>>> Gert Kok wrote:
>>>
>>>> When a new calculated field 'calcfield' is created, a 'SIGMA values'
>>>> is added to the column-labels-area, and a 'sum of 'calcfield' is
>>>> added to the values-area.
>>>>
>>>> But I want to use the new field in the row-labels-area, and it is
>>>> impossible to move the new field to that destination.
>>>>
>>>>
>>>> When I read books about Pivot tables for Excel 2003, it looks like
>>>> the calculated fields should behave like other fields in this respect.
>>>>
>>>>
>>>> Do I see over some checkmark?
>>>
>>>
>>>
>>
>
>