Apartment Matrix by Level - List Structure Help

Hi All,

Trying to generate an apartment development schedule to export into excel into the following format;

There are 79 Apartment Types & 47 Levels

I have collected the apartment areas by level & collected all the apartment types that need to check against each level.

(data in excel attached)

The output I am trying to achieve is 47 lists of 79 counts of apt type.

Any help is greatly appreciated.

APTbyLevel-APTtypes_DynamoExport.xlsx (11.2 KB)

Hello. Can you attach your Dynamo graph too? And the excel you attached is the output of your current graph, not the data you used to make it?

I can’t test using your data, but something along these lines should work:

The last node, List.CountTrue uses “Keep List Structure” option (shown by the blue), which requires you to set it, save the graph, close and reopen, for it to work.

1 Like

Hey Kenny,

Thank you very much for your help, it worked a treat!

1 Like