IF Contains
- 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 have a dataset similar to this and need to:
* Count the number of rows with the word "Fruit" and "Carbs"
* Sum the amount of requests, per type - also, need the date record as well
* Sum the price, per Type - also, need the date record as well
Date | Type | Amount of requests | Price |
01/01/2020 | Fruit Banana | 20 | 10 |
03/01/2020 | Fruit Apple | 30 | 10 |
01/01/2020 | Carbs Pasta | 10 | 15 |
02/01/2020 | Carbs Rice | 10 | 15 |
Can you help me?
Thank you 🙂
Solved! Go to Solution.
- Labels:
- Tips and Tricks
- Transformation
- Workflow
- 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
How do you want the Date Record to be shown for a Sum operation?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It's working well. However, in my result I still can see different rows for Fruit Bananas and Fruit Apple. I needed these "merged" together", as fruit
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In the second browse tool , you will see the results in the "merged form", since you are grouping by the Type_II field. That's the results you are looking for.
However, if you want more details, in the third browse tool, you are also grouping by Type.
In your case, to see the results in the required form, you just need to pay attention to browse tool 1 and 2.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator