How to consolidate data?

Support
#1

Hello. Need some help.

I have several machines that sometimes makes the same product.
Example:
m1: 100 apples
m2 : 50 oranges
m3: 200 apples
m4: 10 apples
m5: 140 pineapples

Is there a way to consolidate all the unique products into:
310 apples
50 oranges
140 pineapples

The grouping report does this but it is not what I need… I have to continue working with the consolidated data to assign cost and make the inventory entry.

Cheers

1 Like
#2

Hi,

Can you send support@ragic.com an email with the sheet link and elaborate more of this use case,
we need more information to give you appropriate advices.

Thanks!

#3

Hi and happy 20Plenty:grinning:

I wanted to know if you found a solution as I have a similair need.

Thanks

#4

Hello.
No. I havent contact them. But I dont think it is possible.

#5

Maybe using https://www.ragic.com/intl/en/doc/18/Formulas#conditional_sumif in a way might work.

#6

Yes, you are right. I actually use SUMIF in other occassions where there are few fixed items.

ext
ext1356×428 80.4 KB

But there are cases when I have items that change measures everyday and are way too many to list them.
Capture1

#7

Hi,
To consolidate simple unique products,ragic Pivot report can be used.

ragic_pivot
ragic_pivot1194×484 113 KB

To consolidate complicated one, need to write some javascript code or other tools.

multi-level
multi-level914×651 108 KB

#8

Thanks for the responses. Both the Grouping Report and the Pivot Report will consolidate (group) them. However what I need is not a report. The problem is that I need the information (in this case the group totals) within the sheet, for further calculations.

In Excel i use the pivot table to group them and then apply a price. Then total these prices daily.Capture2

By the way this is not a deal breaker for me. What I have to do is apply the price individually to every entry. Then the use the Grouping Report.

1 Like
#9

Any update on a Pivot table function on Ragic?

1 Like
#10

Hi,

Not quite sure what kind of updates you’re looking for. Would you mind elaborating more on this?

#11

what I am hoping is to have a Pivot table where the output values can then be used in vlookup or link & load function.
same as regular excell/gsheets pivot table function.

this will greatly increase the functionality of Ragic, since we can then generate pivot tables with a unique identifier for a set of original values.
currently I need to export the data to excel, generate a pivot table, then import the table again to ragic so i have a unique value that can then be referenced.

i hope this aditional explanation helps to define the need.
best

#12

There is a new command that you can experiment on.
On form tools, convert records, advanced, checkbox “Apply subtable grouping criteria”