Apply "reverse" map

[Gestion-PSD]

Hi all!

We're developing an dashboard with data categorized by [client] and [date] (and [Hour] and [Type]). We must apply a "reverse" mapping for [clients], because values for one original client must be splitted 53%-47% between two clients.

Splitting should viewed on dashboard and nprinting reports (I mean, it's enough if we split data on expressions or calculated dimensions), but I think it's better to split data  on data model.

This is a sample of the data to be splitted (Incoming, Min_In, Outgoing, Min_Out)

And example would be splitting 179 Comercia_COMER400 Incomings for 09/07/2020 10:00 to 94.87 for Comer401 and 84.13 for Comer402.

Have someone an idea about how to do that? 

Regards

Alonso Torres