I want to use a crosstab within Crystal Report Studio to display the revenues of several months of each customer in a single row. (in the underlying database the revenues of each month are stored in a seperate row). So far so good.
I have put the customer id to the row, the date_id to the column and the kpi revenue as group field.
But I want to use further describing db columns in front of the kpi, additionally to the customer id, for example the customer name, customer city and so on. But I don't know how I can do this. Is there any possibility?
I don't want to create a formular and concatenate the columns, because then I don't have the columns of the different customers amoung each other.
So is there another approach.