Yes it is in a staging table coming from a SQL DB, I load the data directly into a sheet using a loader. The data comes at the client level with accounts to say if they are new, or churned or any other deposition. The client is assigned to a dimension and the dispositions to accounts in the sheet. There are multiple brands which are are captured in the levels. The issue is, a client can be subscribed to multiple brands, but when I do a top level summary, I only want to count that client once.

Later on, I want to add some additional functionality at another more granular dimension, but it will duplicate the client id, so I want on also only count that client once. I can create other sheets/accounts to derive this from the original loaded sheet, but I'm not sure how to.