Total Amortized cost, year_month and Company are not computed but part of the original data set. I will share the computation for direct cost as below -
Company Category = ifelse(isNull(Company),‘Null’,ifelse(Company<>‘ABC Corp’,‘Customer’,‘Central’))
Direct cost = sumOver(sum({total_amortized_cost}),[{Company Category},{year_month}])
Direct Cost% = sumif({total_amortized_cost},{Company Category}=‘Customer’)/({Direct cost })
I am going to archive this topic since it has been open for an extended period of time. If you would still like assistance with this, or if you have a new QuickSight question, feel free to post a new topic in the community so you will be at the top of the priority list for a response from one of our QuickSight experts. Thank you!