PivotTables: Caluclated field shows No Value in summary Sum (or other summary functions)

[lalbatros]

Hello,

I use many calculated fields in my pivot tables.
This is to avoid populating my worksheets with additional data.

However, this comes with a problem.
The summary data for these calculated fields are not shown in the pivottables.

The summary data appear only when there is one unique row level (column level).
When there is a hierarchy of row levels, the summary sum is not shown, except if the details are collapsed!
However, a drill down on the empty cell return the right list of records from which I can indeed evaluate the summary sum.

It looks like a bug or a semantic prudence (in case the calculated fields would not be semantically summable).

Nevertheless, I am not able to see summary totals for these fields, and this is really annoying.
Would you have a suggestion to get these summary sums on my pivot tables without create these data explicitely in my data source?

Thanks,

Michel

 

[Fazza]

Yes, Michel. Create the fields via SQL instead of as calculated fields. Suggest you search for old threads where I've done this. I have to go right now, sorry: received an unexpected call. I can re-visit tomorrow. regards