SOLVED
Count of variables in multigrouping
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
ievpal
7 - Meteor
‎10-19-2016
05:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi everyone,
I haven`t been able to solve this problem for a few days now. I have a data set that needs to be grouped and have the count of how many times this variable appeared in this group as shown bellow. However, everytime I try to group these variables and when I try to find the count of these variable I can only find a right count for Var1.
Sample input data set:
Required result:
Thank you.
Solved! Go to Solution.
Labels:
3 REPLIES 3
pcatterson
11 - Bolide
‎10-19-2016
07:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎10-19-2016
11:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you. It`s more than I had.
But it would still be very nice to have Var1 mentioned only once, like we can have in pivot tables. Is that even possible? :)
pcatterson
11 - Bolide
‎10-20-2016
05:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
