Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | |
Uncelar from your question what exactly you want... Can you provide the result you are looking for...? Thanks
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
Can you please share the app.
hi
have a look at the attach example
hope it helps you