Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
What is your calculated expression you are using?
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
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?
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.
Can you share a sample to look into please??