- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

count of occurrences of subcategories
We have a category of data that has multiple options, its called doc type and it has options that are dwg, vdwg, sop. I was wondering if there was a way to get a count of how many items are dwg, and how many are vdwg, etc, and what the best way to do it is so that we can take the data and put it in a table. For example it should look like this
DWG | VDWG | SOP |
25 | 145 | 245 |
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

HI @dreynolds
Your scenario sounds very similar to the linked discussion (i attache there a sample file with solution):
Please refer to or provide some sample data and expected output
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

HI @dreynolds
Your scenario sounds very similar to the linked discussion (i attache there a sample file with solution):
Please refer to or provide some sample data and expected output
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

could you pls provide some sample data and expected output?
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
02-15-2025 03:12 PM | |||
09-01-2024 08:06 AM | |||
07-13-2024 07:55 AM | |||
09-09-2024 05:05 AM | |||
01-15-2025 05:58 AM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |