Skip to Content
0
Former Member
May 16, 2016 at 09:23 AM

How to include the Filtered values from cji3 Report to Spreadsheet for which the following message pops up"Filter criteria, sorting, totals and subtotals are not taken into account"

1361 Views

Hi All,

when i am extracting the report from Cji3 report into spreadsheet , i am getting following message.

"Filter criteria, sorting, totals and subtotals are not taken into account"

This is a standard message which you will be receiving when converting any reports directly into Excel i.e Spreadsheet .

What it means is even if you have used filter option for sorting purpose and after this step if u click on Spreadsheet icon

(ContrlShiftF7).the system shows all the values in spreadsheet and it does not convert only the filtered values.

My requirement is

Is there any SAP note or setting which can be done so that when i am extracting the report to spreadsheet, it should also include all the Filtered Values.

Thanks in advance.

Sanket G