Sum attribute according to another attribute ?

[Anonymous]

Hi everybody,

Here is what i want to be helped, i have many attribute blocks with various names and each block has two attributes, one is a string and another is a number . Then i want to sum all tag value number that have the same String.

For example : 

                     Block 1      Block 2    Block3      Block4   

Block name :  Lamp1        Lamp2       Lamp3          Lamp4    

Attribute 1 :     L1             L2              L1               L2         

Attribure 2 :    50             100           20               70         

Then the result i expected is  a report as below:

String              Block name             Total

L1                Lamp1, Lamp3             70

L2                Lamp2, Lamp4             170

Thank in advance for your help !

[braudpat · Accepted solution]

Hello

Welcome to the Autodesk/AutoCAD Forums !

I think that using ATTOUT (Express Tools Command), you will generate a CSV file with :

Handle , Block Name , Attribute1 , Attribute2 , etc

Then you load the CSV into Excel, and you can do the job (with Excel) ...

[Anonymous · Accepted solution]

Hi braudpat,

That's great, i used ATTOUT and export to a txt file, I pasted all of data to excel and then use Pivot Table tool . It took me just 3 minutes to get what i need .

Thank you very much !