Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Cross tab drill down

Greetings all

I have a challange!!!!!!

I have created a crosstab report showing a list of wards acroos the columns and a list of days for each row. The data is the number of patients on each by day. The customer would wish to click on the number of patients on Ward 15 on the 15 Sep 08 and see a drill down (or sub report on demand) of a list of patient names on the ward.

Any ideas?

Thank you in anticipation

Kevin

Former Member
replied

Hi Kevin

A drill down on a part of a cross tab can not be done.

However there is a workaround for your requirement: For example my data is: column for cross tab is Countryname, row is region name and the summarized value is last year's sales.

1. Create a group on country on main report.

2. Insert a subreport in the detailed section.

3. Insert cross tab with region as column and last year's sales in summarized value.

4. Link the subreport for country with main report.

Now you would be able to drill down for the group of records for a particular country through this subreport and that also in a cross tab.

Hope this helps!!!!

Regards

Sourashree

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question