Skip to Content
0
Former Member
Jul 28, 2011 at 07:42 AM

Cross Tab Report Issue...

21 Views

Dear Team,

I have following situation...

I have to convert the following data into CrossTab.. I am converting it into cross tab and receive following output...

material  Quarter QTY       Ratio FIN_month
25048160  1    246226.579  1    Jan
25048160  1    4123.105     1    Feb
25048160  1    4484.587     1    March
                254834.271   
25048160  2    39494.051    1    April
25048160  2    17089.269    1    May
25048160  2    3374.557     1    Jun
                59957.877

CROSSTAB output i am getting...is show below..

        Quarter         
           1                 2   
Material   sum(QTY)   Ratio   sum(QTY)   Ratio
25048160   254834.271   3   59957.877      3 

n this output sum(qty) is correct...But BO is doing sum for Ratio also which is wrong...

There is no operation defined at column "ratio" at the universe level...

To over come this issue i wrote the formula

max(Ratio) foreach (Material, Quarter), but still i am not receiving the required output..

Despite this formula BO is doing SUM which is wrong...

My expected output is given below...

   Quarter         
           1                 2   
Material   sum(QTY)   Ratio   sum(QTY)   Ratio
25048160   254834.271   1   59957.877      1 

Kindly give me some tips how to achieve this 😔

Regards

nic