Hey everyone! New here…Hope my question makes sense!
I’ve created a table to track my book sales and royalties. It works super great!
However, I’d like to link a TOTAL ROYALTIES table to the SUM of every month’s royalties, but I can’t figure out how to do that.
A book’s table has columns for month, downloads and royalties by type (ebook, print, audiobook, etc.) and total monthly royalties (which is calculated using a formula).
The summary bar for the monthly royalties shows the number I’d like to see in the Total Royalties Table, where I’d like to see ALL my books and all their earnings.
IS there a way to pull the data from the summary bar into another table? OR is there a way to see the summary bar info on a card in gallery view?
Thanks so much for any help you can offer!
P.S. It looks like I might be able to do what I need with a Pivot Table, but I don’t want to pay the $20/month - it’s just a lot more functionality than I need. I’d rather find a workaround, if possible.