Hi All,
I need help with the below mentioned question :
Input :
Curreny Year Profit
CURRENY YEAR SALE
Product
JAN
FEB
MARCH
APRIL
MAY
JUNE
JAN
FEB
MARCH
APRIL
MAY
JUNE
A
1
1
1
1
1
1
1
1
1
1
1
1
B
2
2
2
2
2
2
2
2
2
2
2
2
C
3
3
3
3
3
3
3
3
3
3
3
3
D
4
4
4
4
4
4
4
4
4
4
4
4
E
5
5
5
5
5
5
5
5
5
5
5
5
F
6
6
6
6
6
6
6
6
6
6
6
6
Expected Output :
Product
KPI
Month
Values
A
Curreny Year Profit
JAN
1
B
Curreny Year Profit
JAN
2
C
Curreny Year Profit
JAN
3
D
Curreny Year Profit
JAN
4
E
Curreny Year Profit
JAN
5
F
Curreny Year Profit
JAN
6
A
Curreny Year Profit
FEB
1
B
Curreny Year Profit
FEB
2
C
Curreny Year Profit
FEB
3
D
Curreny Year Profit
FEB
4
E
Curreny Year Profit
FEB
5
F
Curreny Year Profit
FEB
6
A
CURRENY YEAR SALE
JAN
1
B
CURRENY YEAR SALE
JAN
2
C
CURRENY YEAR SALE
JAN
3
D
CURRENY YEAR SALE
JAN
4
E
CURRENY YEAR SALE
JAN
5
F
CURRENY YEAR SALE
JAN
6
A
CURRENY YEAR SALE
FEB
1
B
CURRENY YEAR SALE
FEB
2
C
CURRENY YEAR SALE
FEB
3
D
CURRENY YEAR SALE
FEB
4
E
CURRENY YEAR SALE
FEB
5
F
CURRENY YEAR SALE
FEB
6
Please help!
Thanks and Regards
Harsh