subtotals in separate

[DANI-3D]

Hello, colleagues
I have made a table, to pass to the purchases, to order the iron, where I have summarized all the necessary materials with lengths, unit weights and total item per item. what they ask me is the sum of the equal voices, the subtotals of the lines enclosed in the red rectangle of the attached image.
You think it's feasible, I did some evidence, a little fast, but I couldn't.
thanks to the intention.

 

[320i S]

there are several ways, what I found simpler is to create a bom table, with a relationship where to discriminate objects with a certain feature (can be a raw material code, a specific parameter etc), and then sum the necessary parameter to the total (length if you go in meters, pro_mp_mass directly if you go to weight), of course if the amount used of each individual item is greater than 1,you should also make partial multiplication.
If I can find the table I used a few years ago, I'll put it on you.

 

[DANI-3D]

there are several ways, what I found simpler is to create a bom table, with a relationship where to discriminate objects with a certain feature (can be a raw material code, a specific parameter etc), and then sum the necessary parameter to the total (length if you go in meters, pro_mp_mass directly if you go to weight), of course if the amount used of each individual item is greater than 1,you should also make partial multiplication.
If I can find the table I used a few years ago, I'll put it on you.

Thank you very much.

 

[DANI-3D]

... create a bom table, with a relationship where to discriminate objects with a certain characteristic ...

but the method is that of the nested tables?

 

[320i S]

what I have proposed above no, does not include nested cells, because you make a discriminating between models, which exculses all models that do not correspond to the code or parameter you go to sum.

 

[DANI-3D]

Unfortunately I do not understand what method you use.
I remain waiting for the example, or other info.
Thank you.

 

[320i S]

I got this, see if you're okay.

 

[DANI-3D]

I got this, see if you're okay.

Thank you, Monday I try and let you know

 

[DANI-3D]

I got this, see if you're okay.

I'm trying with your table, but it doesn't work.
after inserting it I changed the name of the parameters by putting those I use:
&asm.mbr.codice varies in &asm.mbr.cod_diseg
&asm.mbr.description varied in &asm.mbr.description
other parameters have the same name

in the table I changed the filter:
&asm.mbr.codice == varied code in &asm.mbr.cod_diseg == cod_diseg

Is that right what I did?

 

[320i S]

the table I turned you, makes the sum of a parameter called "lung", which I used for the length in meters of details.
the table also has cells reduced to the minimum of width and font size, for partial calculations (i.e. the quantities used).
to understand us better, I recommend:
- enlarge all table cells and its text
-change the sum parameter with what you need.

here are the explanations on how to create the summary table:http://support.ptc.com/help/creo/cr..._summation_of_parameter_values_of_a_repe.html http://support.ptc.com/help/creo/cr...age/detail/example_summation_parameters.html#

 

[DANI-3D]

However, the method you are describing me, which I know and use every now and then, gives me the sum of all the lines that contain far, while what I would like to accomplish are so many sub-totals for each group of rows with the same description.

 

[320i S]

the problem is that if you want to use only one table, it is very complicated and manageable at all if you have the same parameters to be added with different materials or codes.
for this I have made a table like this, insert one for each code/matter before you have to sum, you just have to put a different final sum parameter (but you ask me to create it automatically), which you should manage by hand for every new code/matter first and respective partial parameters that you have with a unique table (which becomes absurd).
if you notice the example of ptc concerns an existing parameter on all (cost), but already if you describe 2 different parameters (length and weight), the example is no longer valid.

 

[DANI-3D]

the problem is that if you want to use only one table, it is very complicated and manageable at all if you have the same parameters to be added with different materials or codes.

I suppose, it was the doubt I had from the beginning.. I hoped for a possible feasible solution.
Thanks anyway.

 

[DANI-3D]

I haven't given up yet.
At least at the theoretical level I would have found a method to make the subtotals of the same voices in a distinct, I added a progress column, which increases by making the sum of the lengths of the similar articles. when changing the description departs from zero.
The trouble is I can't get the right sums, it's like he's wrong to make the calculations.
Can you give me an eye to see if we find a solution together? Maybe it can also serve others.
Thank you 1000.

 

[DANI-3D]

And... I did well not give up, found the solution. It was not easy, I had to draw on all the militias of a former programmer.
I attach the drw with the table, if it can be useful, take advantage of it as well.
greetings