HI All,
I developed Query which will is giving me output in following format in Bex Analyzer , but user want it in different format
Please help me .
Currently i am showing as
Material | value | cane value
000001 | 1234 |
000002 | 3467 |
CANE | XXXXX| 45,506.00
but my user want to display value of material 'CANE' in Heading not in Row , i can hide it in column in Query designer but i cant able to show it in Heading
Also there r some calculations based on CANE value, hence i need to use the value of CANE
Please HELP
Thanks & Regards