Add one fixed column to Cross-Tab 1

[Slingky]

i have the following cross-tab.
it's a price list by customer

item# Cust1 Cust2 Cust3
100 1.52 1.74 1.66
101 1.38 1.33 1.55
102 1.99 2.08 3.06

all works good except that i want to add an extra column which is the standard cost which is same for all customers.

how to do this ?
I can't create a manual crosstab as i have > 150 customers.
and displaying 2 rows is too much... (cause we have > 1200 products per customer)

so how to add just this column ???

help needed.

 

[Slingky]

is the only solution to create a report grouped by item# then place a subreport containing the cross-tab ?

 

[lbass]

Try adding a separate crosstab just for the standard price where you use the item # as the row, the price as the summary, and use no column field. You could place this on the left and then format your other crosstab to suppress the row labels and remove the gridlines for the labels, so that it appears as one crosstab.

-LB

 

[Slingky]

wow, this is nice...except one thing.

when i export this to excel, i get all except the new column ?

how may i make it appear like the other cross-tab ?
is it related to "move backward" or something like this ?

 

[Slingky]

no sorry, the appear one after each other.

do i have to put grid or something ?

thanks again

 

[lbass]

I don't know much about export issues, as I rarely export out of CR.

-LB