need help with expression

[#1]

hi,

I am using  pivot table,I need expression for

total of month real value/total of years real value           and where measure is kg I need

total of month value/product's equal value under real

in one expression

product	qty	real	measure	month	year
apple	1	2	kg	apr	2010
mango	1	4	kg	apr	2010
headphone	1	8	piece	apr	2010
milk	1	9	ltr	apr	2010
equal	1	45		apr	2010
apple	1	3	kg	may	2010
mango	1	5	kg	may	2010
headphone	1	6	piece	may	2010
milk	1	8	ltr	may	2010
equal	1	93		may	2010
apple	1	2	kg	jan	2011
mango	1	6	kg	jan	2011
headphone	1	7	piece	jan	2011
milk	1	8	ltr	jan	2011
equal	1	87		jan	2011

[MK_QSL]

Uncelar from your question what exactly you want... Can you provide the result you are looking for...? Thanks

[#3]

hi,

I jus need the expression
for

total of months real(column) value/total of years real(column) value and if measure is kg then I want

total of months real(column) value/Products column equal's value under real.

for eg

total of apr months real value is 68 and total of 2010 real's value is 183

so I want 68/183 and in case if measue is kg then I want

68/products column equals value under real column.

==products column equal value under real for month apr is 45 for may it is 93 and for jan its 87

so I want 68 /45 for apr
and likewise  if measure id kg

this thing in one expression

[avinashelite]

Can you please share the app.

[lironbaram]

hi

have a look at the attach example

hope it helps you