I'm trying to implement model where users could easily apply filters on customer list based on segments and subsegments. Problem is that when the user list is filtered by segment or subsegment the customer total doesn't change. Filter is made on user level.
Amount of customers, products and users is so high that I can't add users as dimension to reporting model as the model size would grow too much. Is there any workaround that I could use to solve this problem with customer totals and filtered customer list?