Hi All,

I have a requirement in my project to create the report structure as below in table 2, where I need to create Component total and Stage totals as local members which will sum up to show the totals of each component and sum of all components under one stage respectively.

Components and stage are related via master data and attributes.

Please find the same below in table 1

Please help me, how the same can be accomplished in sheets. Components, Fund and Fundcenter are dynamic members in the sheet that may change based on the selection parameters.

Regards,

Sreeja V