Hi @pantelis,
The problem with your calculated field is that it is trying to access the field “company_id” in an unaggregated manner, while aggregating the subscription revenue. It would be helpful if you could create an anonymized example on the Quick Sight Arena using some sample input data and telling us how the expected output should look like. Sharing this with the community makes it easier to support calculated field related questions. Thanks in advance.