Hi all,
We have one requirement where in we need avg value in 1 column and the sum of qty in other in other column.
For eg: we need
Material Vendor price1 price2 Qty Value1 Value2
Mat1 V1 10 15 4 10x4 15x4
Mat1 V2 10 18 7 10x7 18x4
In above report output,
Price1- this should be the average price of material based on all non zero price1 entries in cube (contains doc numbers doc item etc.)
Price2- whereas this should be the average price of material for a vendor based on all non zero price2 entries in cube (contains doc numbers doc item etc.)
qty is normal summation and Value1 and value2 are derived as shown.
Since all of them are at diffrent level i cannot use column formulas etc.
Can anybody suggest how to achieve this.
I would appreciate any help by rewarding points.
Thanks in advance.
Wrushali