sum

[upaliwije]

Hi,

In my QV documents I have following Pivot TAble

			No of Items
ITEM	VALUE	U_COST	=(VALUE)/(U_COST)
Card Printers	3,840,000	160,000	24
Structured Data 1 point	6,000	6,000	1
TFT Panels	168,000	14,000	12
UPS (650VA)	748,000	8,500	88
Total	4,762,000	646,500	7.365815932

Expected Value                                            125

Pls help me to arrive expected Value (125)in total row of No of Items

[sunny_talwar]

I think you won't be able to achieve the result you are hoping to see with column labels. You will need to use the expressions with Aggr () function like this:

Sum(Aggr(Expression for VALUE/Expression for U_COST, ITEM))

[upaliwije]

Thanks Sunny,

What do mean by Expression for VALUE/

                                 Expression for U_COST

Can you elaborate little more pls

[sunny_talwar]

Are VALUE and U_COST field names from your database?

[upaliwije]

Yes Those are fields in my database

[sunny_talwar]

Try this:

Sum(VALUE/U_COST)

or

Sum(Aggr(VALUE/U_COST, ITEM))

[sunny_talwar · Accepted solution]

Here is a sample:

[upaliwije]

thanks Sunny

[sunny_talwar]

No problem