Sum() aggregation of dependent field

[frank1982]

Hello,

I have to build into a pivot table a field a function like this

=Sum([Prezzo Peak simulato]*PEAKLOAD_N)

or

=Sum(Column(1)*PEAKLOAD_N)

where

Prezzo Peak simulato is the first column of my table.

PEAKLOAD_N is a database field.

The aggregation formula doesn't work.

How can I write this formula to obtain the sum of this calculated field?

Thank you very much.

[vishsaggi]

What is your calculated expression you are using?

[frank1982]

Now I'm using the first expression :

=Sum([Prezzo Peak simulato]*PEAKLOAD_N)

but i would like to know a solution also for the second one expression.

Thanks

[vishsaggi]

Sorry I believe I understood you correctly, Can you elaborate a little, with a sample file and expected output would help a lot. Correct me here

YOu want to sum() on Sum(Prezzo peak simulator* peakload_n) is this what you are looking for?

[frank1982]

Oh, I'm sorry, I've forgot an important feature of my pivot table: I have a time hierarchical dimension like Year-Month-Day-Hour.

So, I'm looking for the sum of my field for each dimensional aggregation.

[vishsaggi]

Can you share a sample to look into please??