Totals, number data group by

[monoquad]

Hi!
Here lies the deposits list in the repeating group (right side).

I need the totals (sum of amounts) of deposits by currencies (BTC and USD).
I created a repeating group for currencies (left side) and get the sum of deposits - not good, because I need to show there only unique currencies and sums of deposit amounts by these currencies.
Sure, that I’m doing it wrong, but I don’t’ understand how to do it proper way.
I need your help here! Thanks in advance!

[mikeloc]

Hi there, @monoquad… I used the data that are visible in your screenshot, and here is the result…

If that’s what you are shooting for, here is the configuration of the repeating group…

Hope this helps!

Best…
Mike

[monoquad]

hi!) I don’t undrestantd how you get that “Group By” window

[mikeloc]

It’s one of the More options on the data source’s search…

Make sense?

Best…
Mike

[monoquad]

and what content should place in Amount cells to sum deposits by currencies?

[monoquad]

now I’m just getting the total sum of all deposits

[mikeloc]

Can you share some screenshots of your db setup and your Group By setup?

[monoquad]

yes!

• Transaction DB
  
  
• Main repeating group (transactions list)
  
  
• Grouping repeating group
  
  
  
  – Field in grouping RG 1 (Currency)
  
  
  
  – Field in grouping RG 2 (Amount)
  
  

[mikeloc]

The problem is with the last screenshot because your search is still summing all of the transactions. That field should be something like Current cell's Grouping's sum of Amount. If you don’t have that as an option, take a look at the screenshot in my original response again and make sure you have set up the aggregation.

[monoquad]

maybe, but I can’t choose that option

[monoquad]

this worked - thank you!!!