Impromptu - Making Cross Tab Report

[MitraMIS]

I'm trying to make a crosstab report with multiple columns.

Part Nbr Current Week 1st week 2ndweek .....
A Qty * Price Qty * Price Qty * Price
B Qty * Price Qty * Price Qty * Price
.
.
.
I need each Column to have different Condition on Date. Once I set up the condition, it will applies to all columns. How can I set up the condition for each column seperately.

TIA

 

[GilMerc]

Hi Tia,

Effectively, if you put a filter all column will be affect of this condition.

I think you must do a view where in each occurrence will be identified on wich week it will be inserted. After this, it will be easier to take cross table because the relation will take on this new column.

Gilles.