Sum parent only for items where I have access to

jjwikselaar

Hi, I'm trying to create a sum on parent level, that only includes the items where I have access to. I attached an example. 

 

The only way I can think of is to add the users as a dimension to the modules and create an extra line item that only gets the number if the user have access to the item and then use this extra line item to show on parent level. 

The issue is that this will have a big impact on the size of the model. 

 

Is there a way to do this, without adding the user as a dimension?

 

Thanks,

JJ

jjwikselaar

Thanks for the suggestions! we have set it up as option 2 now...