Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a Pivot Table and I have the following expression:
a.
=Sum(EXECUTIONS_DELTA)
and
b.
=Sum(ELAPSED_TIME_DELTA)/if(Sum(EXECUTIONS_DELTA)=0,1,Sum(EXECUTIONS_DELTA))/1000
and
c.
=sum(IOWAIT_DELTA)/if(sum(EXECUTIONS_DELTA)=0,1,sum(EXECUTIONS_DELTA))/1000
These are grouped by Time, "Type of call" and "SQLs_USED in particular call"
Question:
I want partial max value of "a" and partial sum of "b" and partial sum of "c". As of now I get wrong values after I click "show partial values" under presentation tab.
Regards,
Anybody ?
can you attach the app if possible? or at least highlight the figures in a screenshot where you think the figures have gone wrong?