sum of total

[#1]

Hi there,

How can i do a sum of total X / sum of total Y

example show in excel pivot table

[vipin_mishra479]

Please try this

sum( TOTAL PM_WAIT_TIME_Q) /Count(TOTAL CNTR_N)

may be this will help you out

[sunny_talwar]

Looking to get this?

Expression:

Sum(PM_WAIT_TIME_Q)/Count (CNTR_N)

[Chanty4u]

did u chkd my attached qvw?

[#5]

Hi Sunny,

Yes.

[#6]

Hi

Yes, sunny got the solution too.

[HirisH_V7]

Hi ,

Whats Your Required Output!

Three expressions possibility,

Sum(PM_WAIT_TIME_Q) /Count( CNTR_N)

Exp(Sum(PM_WAIT_TIME_Q) /Count(Subfield(CNTR_N,' ',2)))

Exp(Sum(PM_WAIT_TIME_Q) /Sum(Subfield(CNTR_N,' ',2)))

PFA,

Hirish

[sunny_talwar]

So did you get what you were looking for?

[#9]

Yes:)

[sunny_talwar]

In that case, I would request you to close the thread down by selecting correct and helpful answers.