Dataset Building

[knnwndlm]

Hi SME,

I have a dataset in columns A-C in the attached Excel file.  I would like to create a new table based on the input in cells I5:J8.  For example, for stratum 1, I would like to pick up the total amount for the first 13 rows, for stratum 2 the first 10 and for stratum 3 the first 11.  The end result is the cells L5:M8.  Since the input in cells I5:J8 could change, I need to make this dynamic.

I supposed that I could do this the long way.  Could you please help me figure out the best approach to this?  Appreciate your help.

Thanks,

kwl

[Yoshiro_Fujimori · Accepted solution]

Hi @knnwndlm ,

Here is one way of doing this.

Workflow

Output

(You may remove unnecessary columns with Select tool.)

I hope this helps.

[knnwndlm]

Thank you @Yoshiro_Fujimori