Hello !

We are using Cognos V7. We need to pivot data for the report.

Ex.
LINE CATEGORY QTY
FRONT A 2
BACK A 3
FRONT B 1
BACK B 7
FRONT C 5

Which Means total FRONT=8 BACK=10

Desired Outcome Would be

LINE CATEGORY-A-% CATEGORY-B-% CATEGORY-C-%

FRONT 2/8 1/8 5/8
BACK 3/10 7/10 NULL


If we use Cross-tab report option then we can't save report into Excel.

We tried using SUM around CASE statement but Cognos would hick up on NULLS

Any Ideas ? Is there a way to store Calculations in Catalog as summary items and then use as columns ? And be able to save into excel ?

thanks