The Subsets Tab and the Calculations Tab

 

Subsets are a very important feature in PowerExcel, whether they are Custom Subsets, created by users in PowerExcel—as explained in this section—or created in Olation®, the modeling engine that PowerExcel reaches for users to plan, analyze, and report on data.

 

What are Subsets and why are they important? in brief, a Subset is a saved list of Dimension members. The importance of Subsets is that they allow users to select saved lists with a click or two to create reports, templates, board books and the like in Excel. In other words, rather than navigate to select the list of Members with each report, etc., the Subset is at hand for immediate access, saving time and effort in PowerExcel.



Click the links to easily navigate to the corresponding sub-topics under this section: