I have to "translate" a report from a new data source which doesn't match the original. In the old data source, I had Mega Segments in Column C (Groups, Wholesale, Retail, etc), and the new one in Column B has a much more atomized segmentation (Leisure Groups, Corporate Groups, etc) with their own values. I need to translate the new 28 segments into the old 11 segments, and have the columns "subtotal" these new segments:
The report uses 2022-M12 as date, and goes on for 12 months. I would need a new report showing the totals of each "translated" segment for each of the 11 Mega Segments. In the example above, I would need a 2022-M12 line to have GROUP as Segment, and have a total of the 5 Groups lines from Column C, as follows:
The report uses 2022-M12 as date, and goes on for 12 months. I would need a new report showing the totals of each "translated" segment for each of the 11 Mega Segments. In the example above, I would need a 2022-M12 line to have GROUP as Segment, and have a total of the 5 Groups lines from Column C, as follows: