SOLVED
Creating a new column from filter
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
ksmith4567
6 - Meteoroid
‎01-21-2022
08:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi there I am trying to use a filter that contains string values to then create a new column with number values. Example data below:
I have the following:
Person | Fruit | Sales |
Ann | Apple | 100 |
Jeff | Orange | 200 |
Ann | Apple | 400 |
Ann | Orange | 500 |
I want to filter to just rows with Apple sales so that I can then summarize the data with Apple Sales being a new column rather than having a fruit flag:
Person | Sales | Apple Sales |
Ann | 1000 | 500 |
Jeff | 200 | 0 |
Is anyone able to assist? Thank you!
Solved! Go to Solution.
Labels:
- Labels:
- Join
3 REPLIES 3
22 - Nova
‎01-21-2022
08:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎01-21-2022
08:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you!
22 - Nova
‎01-21-2022
08:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @ksmith4567
Cheers and have a nice day!
