Can't use calculated field for row or column area in Beta 2007

[Gert Kok]

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]

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]

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

 

[Gert Kok]

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]

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]

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