Thanks for the soon reply, Haikuo Yu
I understand the wildmatch but where do I assign the Business Unit? I do not want a new field like new_Business_Segment (unless it is a temporary step), because I need to relocate the cells that contain Project* to the Sales Projects Business Unit... I need to generate charts with the "DesiredResult" table and if I generate new_Business_Segment I can't relate the data to the Sales Projects Business Unit.
I've been thinking in two steps... but without solving the issue of using the same field name, I cannot find the solution.
Any other hints?
datalakeyu, your hint led me to the solution, thanks so much!
This is what I did:
if(WildMatch([Business Segment],'Project*'),'Sales Projects',[Business Unit]) as TempBU2,
(ooxml, embedded labels, table is CurrentData);
Then I use only for my charts TempBU2.