List of sub totals

[Marcel.maas8JMSJ]

Hi all,

Is there a way to list sub totals?
I don’t want to see duplicate fittings in excel, but sub totals instead.
This is what i have so far.

[Draxl_Andreas]

hi,

What do you mean with subtotals?

KR

Andreas

[Marcel.maas8JMSJ]

For example, in the column of NLRS_C_description (the description of the fittings), groove elbow DN40 and groove elbow DN50 are included several times.
I want in excel 1 line with groove elbow DN40 and 1 line with groove elbow DN50.
with the totals.
Here is an example for some pipefittings then maybe you get what i mean?
Export to Excel.rvt (4.9 MB)

[Nick_Boyts]

Sounds like you need GroupByKey to group similar elements. Then you can count or sum totals for each element type.

[Marcel.maas8JMSJ]

Oke thanks, i will dive into that one.

[Draxl_Andreas]