Sum parent only for items where I have access to


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?





Best Answer

  • DavidSmith
    Answer ✓

    If you want the total in the same module then your options are limited. Dynamic sub totalling on girds is something that is in the idea exchange. 


    However, there are a couple of alternatives:


    1. You could utilise a dummy user list and use the access rights to assign the dummy users then sum the totals into a second module.  You can sum over dummy users (something you cannot do with the true Users list)


    2. How static are the access rights?

    You could create a hierarchy under each user (using a dummy user list) and show the total under the grid


    I hope that helps