Hi i am trying to add new column to a crosstab in Business objects. i have a simple cross tab that displays revenue by product and month. jan feb march april product1 100 200 150 1000 product2 120 200 300 400
I want to add a column next to april that displays the maximum revenue for that prouct. unfortunately when i try to insert a new column next to april, with Insert-> column from menu, i am getting one new column next to every month like below
jan max feb max march max april max product1 100 200 150 1000 product2 120 200 300 400
. how do i remove these extra columns? greatly appreciate your help.
Solution: Business objects Crosstab
Hi thank you for your time. i got the solution after talking to a friend. here is what u can do. once u have a cross tab, create a sum or other group function on crosstab from the functions menu. then u will have one column with the sum at the end of cross tab, with sum for each row. u will not see one column for each month (in above example) u can modify this formula using formula bar, for custom formulas. then if u want to add more columns next to it, u can again click the Sum button and add one more next to it. thanks