Can anybody please help me how to generate group wise total in crosstab rep

[Former Member]

Hi i am working in business objects can somebody help me out, how to generate a crosstab report with groupwise totals as given below

A B AB C D CD

Product_1 20 30 50 40 20 60

Product_2 70 20 90 30 20 50

I want AB and CD calculated columns in this crosstab report

Pls help me

[Former Member]

Hi Arvind,

I tested this issue with Demo Universe e-Fashion.

I took Year, SalesRevenue, Quantity Sold, Discount, Margin.

I considered Year as Product 1, Product2 and so onu2026 and SalesRevenue, Quantity Sold, Discount, Margin as A,B,C,D respectively.

I stored calculation (SalesRevenue + Quantity Sold)i.e. (A+B) in Variable1 and (Discount + Margin) i.e.( C+D) in variable2 and itu2019s working fine and looks similar to Your requirement.

If this is not like you want please paste the report data in vertical table format with all objects you are considering as A,B,C,D here so that I can understand better what do mean by u201C how to generate group wise total in crosstab repu201D and how you want the sum of objects.

Thanksu2026

Pratik