Hi As per our requirement is we have say for eg: x plant ,y plants and z plant in thr old report.client wants the new report , x plant should have the values of y and z in the new report. and he does not want to see the y and z in the report, only the values of y and z to be shown under x plant.
we have created only x plant in the new report how to bring the values of y and z in the new report.
any ideas or any valuable inputs needed.
create a total column where the totals of XYZ plant is shown. Hide the plant specific columns to display only the totals column.
Best regards, Christian