Filter Cross Tab?

[Bonediggler1]

Hello -

I have a pivot table in Excel that I am trying to mimic in Crystal. Basically, the columns are months, the rows are product, and the summarized value is revenue. The "Page Field" is customer...so the end user can filter the pivot table by customer. Is there any way to do this in crystal (i.e. set up a system so the end user can filter data by customer?)

Thank you!!!

 

[lbass]

Insert a group on customer and insert a crosstab in the group header or group footer that uses month as the column, product as row, and sum of revenue as the summary field.

Go to report->selection formula->record and add:

{table.customer} = {?Customer}

Assuming you want them to be able to pick multiple customers, the crosstab per group will give you one crosstab per customer. Then go into the section expert->group footer->new page after->x+2 and enter:

not onlastrecord

This will create one page per selected customer.

-LB

 

[Bonediggler1]

Thanks LBass...but when I put the {table.customer} = {?customer} i get the message:

"This field name is not known"


referring to {?customer}

 

[lbass]

You have to create the parameter in the field explorer->parameter->new. Set it up as the same datatype as the customer field. Replace {table.customer} with your actual field name.

-LB

 

[crystalkiwibruce]

If you are using Crystal 2008 or later you could use that selection formula on the "Saved Data" and the user could filter by customer without having to reprocess the database.

Bruce Ferguson

http://www.crystalkiwi.com/nlog.htm