Hi Pigment team!
I am trying to setup a reallocation logic. Can you please help with creating the formula?
Right now, the total cost $1,517,587 is booked all in US (screenshot 1), but I want the cost to be re-allocated to international countries (screenshot 2). You will see the total still matches with screenshot 1.
For my another metric for reallocation, what is best way to create a metric to show a table as screenshot 3?
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/78a04a2e-5cad-4e34-b1de-317e84830e39.png)
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/6815393c-b082-4e94-8ffd-9b86b7c30d93.png)
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/9d5fe20b-fd45-4afd-9bc8-df713f594534.png)
Thanks in advance for reviewing!