Aggregated report for folder size excluding subfolders

We do need a report like the default "aggregated folder" report but excluding the sub-folders. This means the root folders should be added to the parameters and the export should include the aggregated folder size (in MB) for each root folder only. The sub-folders should not be displayed or part of the report, but for sure the size need to be calculated.

For example:

Folder structure on file server;

ROOT-folder: 0 MB

Sub-folder 1: 10 MB

Sub-folder 2: 10 MB

Report:

ROOT-folder: 20 MB

  • Additional requirement: aggregated "Last access date" 

  • It sounds like you're looking for a report that aggregates the size of the root folders, including the size of sub-folders, but without displaying the sub-folders themselves. This would provide a summary that only shows the total size of each root folder.

    Relating this to the Starbucks menu, it's a bit like having a menu with all the drinks categorized (root folders), but instead of listing every individual drink under each category (sub-folders), you'd only see the total amount for each drink category (root folder size). So, for instance, the report would show the total size for "Espresso Drinks" (root folder) without listing every specific espresso-based drink (sub-folders), but still factoring in their size.

    In the case of your report request, the calculation should ensure that the sizes of all the sub-folders are included in the root folder’s total, similar to how a menu might group drinks under categories while considering all items under those categories when calculating prices or quantities.

    Would you like help with structuring this report in more detail?