Total by rows, subtotal by group and column sorting
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
mlozovskaya
8 - Asteroid
‎09-03-2021
11:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a data below where I want to archive 3 things:
1. Sort all data by column in alphabetical order
2. Add total by rows
3. Add subtotal by group and Grand Total
Labels:
- Labels:
- Common Use Cases
5 REPLIES 5
csmith11
11 - Bolide
‎09-03-2021
12:40 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi mlozovskaya,
Does your initial data look like the attached file?
csmith11
11 - Bolide
‎09-03-2021
01:08 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Kamran1991
11 - Bolide
‎09-03-2021
01:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @mlozovskaya
Your question is a little confusing, however initial 2 questions are solved by the joining tool only and rest of the workflow is for last one. I hope this can work.
Thanks!
csmith11
11 - Bolide
‎09-03-2021
02:43 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
csmith11
11 - Bolide
‎09-12-2021
04:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @mlozovskaya
If any of our replies were helpful please consider marking them as the solution, so that others who come across a similar question will be able to easily identify the same solution.
Cheers!
