Hello Everyone,
|
Product
|
22-May
|
22-Jun
|
22-Jul
|
22-Aug
|
|
Online NA
|
|
|
|
|
|
Supply
|
10
|
5
|
|
5
|
|
Demand
|
10
|
5
|
0
|
|
|
Balance
|
10
|
5
|
0
|
5
|
|
Differ
|
5
|
5
|
|
0
|
|
Offline NA
|
|
|
|
|
|
Supply
|
4
|
0
|
0
|
0
|
|
Demand
|
6
|
0
|
|
|
|
Balance
|
7
|
9
|
|
|
|
Differ
|
8
|
8
|
|
0
|
|
Virtual NA
|
|
|
|
|
|
Supply
|
3
|
6
|
0
|
|
|
Demand
|
5
|
6
|
8
|
9
|
|
Balance
|
6
|
6
|
7
|
0
|
|
Differ
|
3
|
5
|
|
|
|
|
|
|
|
|
Image: A
This data has Product ( Online Na/Offline NA/Virtual Na) and has sub category details as Supply/demand/balance/Difference. This view is from Power Bi report.
Issue:
I am pulling this view from Power Bi report but actual output from BI is coming like this: Where rows are moving to column.
|
Product
|
Month
|
Supply
|
Demand
|
Balance
|
Difference
|
|
Online Na
|
22-May
|
10
|
10
|
10
|
5
|
|
Online Na
|
22-Jun
|
5
|
5
|
5
|
5
|
|
Online Na
|
22-Jul
|
|
0
|
0
|
|
|
Online Na
|
22-Aug
|
5
|
|
5
|
0
|
|
Offline NA
|
22-May
|
4
|
6
|
7
|
8
|
|
Offline NA
|
22-Jun
|
0
|
0
|
9
|
8
|
|
Offline NA
|
22-Jul
|
0
|
|
|
|
|
Offline NA
|
22-Aug
|
0
|
|
|
0
|
|
Virtual NA
|
22-May
|
3
|
5
|
6
|
3
|
|
Virtual NA
|
22-Jun
|
6
|
6
|
6
|
5
|
|
Virtual NA
|
22-Jul
|
0
|
8
|
7
|
|
|
Virtual NA
|
22-Aug
|
|
9
|
0
|
|
Image:B
Need help:
I am looking for this report in excel format for further analysis.
How can I convert this excel output , where I can get similar view as 1st image. May be we can use some formulas or create VBcode?
Can you help me with solution? Thanks is advance.
