Reporting Mapping

[rkspareek1992]

Hi,

I have two tables of actual data and target data. The client wants data in as per  below format:

Kindly suggest how I have to map data so that I can create below-mentioned formatting.

Location/ Date	WERKS1	WERKS2	WERKS3	WERKS4
Month Target	1500	1500	350	350
MTD Target	1000	1000	233	233
Total MTD Actual	120	126	132	138
Per Day Target	50	50	12	12
1/4/2018	20	22	24	26
2/4/2018	40	42	44	46
3/4/2018	60	62	64	66
4/4/2018
5/4/2018
6/4/2018
7/4/2018
8/4/2018

[techvarun]

what are the columns in Actual and Target table?

[rkspareek1992]

Columns are Plants (WERKS1...)

[techvarun]

What are the input table Fields and Values? Provide sample

[rkspareek1992]

I have two table one of the target and another one of actual data. I wanted to create one-page report as per above-mentioned format.

1. TargetData:

Date,

Plant,

Target Quantity

2. ActualData:

Date,

Plant,

Actual Quantity