Hi Guys,
I have data in the below format
Product | Order Date | Ship Date |
P1 | 01-Jan-20 | 04-Jan-20 |
P2 | 02-Jan-20 | 05-Jan-20 |
P3 | 06-Jan-20 | 06-Jan-20 |
and want to produce an excel output shown as below,
Ordered | Shipped | |||||
Product | 01-Jan-20 | 02-Jan-20 | 06-Jan-20 | 04-Jan-20 | 05-Jan-20 | 06-Jan-20 |
P1 | 1 | 1 | ||||
P2 | 1 | 1 | ||||
P3 | 1 | 1 |
This looks simple, but I am not sure how to create the top sub header (ordered and shipped). Any help would be appreciated!
Solved! Go to Solution.
@DavidP - Not really 😞 but thanks for your efforts , I managed to fix it myself using a report text and summarize tool! (Attached the workflow)
@ramesh_neel, every day is a school day! I wouldn't have thought of using the summarize tool to combine reporting objects.
I'm definitely banking that idea!
@DavidP - Me neither! I think that feature is a life saver!