Generate Rows Tool - Adding a Total Row
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I am trying to add a total row to my data using the generate rows tool. Can this be done? Below is a screenshot of my data. I need the total to include all values with name that includes "Sum_". I think this is possible, but I think my loop expression needs some help.
Solved! Go to Solution.
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ebledsoe22 ,
Is there any particular reason why you need to use the generate rows tool to calculate the row total?
You could try the following approach too.
 
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Oops--read it as column, not row!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My Ultimate goal is to sum the "Sum_" rows so that I can get a percentage of the total and then multiply those percentages by the value in row "A".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @blingen Thank you for this solution. This was actually very helpful because now I can create a ratio and then multiply by the correct cell using the multiple row formula tool.
