In one of our SharePoint List items are grouped by code folder, let say user selects in the InfoPath code 123 item is moved under folder 123. Each folder has unique permissions groups added.
Client has a requirement where they want reports as they call when a user selects a date range they can see aggregate of X column value for all the records, but the items have unique permissions set. Currently when user selects date range they only view aggregate of X column related to their agency or items they have permission on. Any idea if it is possible to display aggregate value of all items of X column for a user.