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?
Thanks in advance for reviewing!
Best answer by abhilashsawla
Please Try below formula.
if('Country Dimension'='Country Dimension'."US" , '[Final] Hosting Final Actual'[Exclude:'Country Dimension'."US"][Remove:'Country Dimension']*(-1), '[Final] Hosting Final Actual')
+7Please Try below formula.
if('Country Dimension'='Country Dimension'."US" , '[Final] Hosting Final Actual'[Exclude:'Country Dimension'."US"][Remove:'Country Dimension']*(-1), '[Final] Hosting Final Actual')
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.