terezagr
Partner - Creator III
2015-08-28
07:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Set analysis show value where most recent sale was made
I am trying to build a set analysis that would give me a value where most recent sale was made.
My data is as following:
Month Sale Company
1 0 A
2 10 B
3 3 A
4 5 B
In this case I would like to see the following
Company Sale
A 3
B 5
Any suggestions?
503 Views
1 Solution
Accepted Solutions
2015-08-28
08:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use the firstsortedvalue function: firstsortedvalue( Sale, -Month)
talk is cheap, supply exceeds demand
374 Views
4 Replies
2015-08-28
08:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use the firstsortedvalue function: firstsortedvalue( Sale, -Month)
talk is cheap, supply exceeds demand
375 Views
stigchel
Partner - Master
2015-08-28
08:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not sure why you want to use set analysis, for expression with company as dimension you can use
FirstSortedValue(Sale,-Month)
374 Views
kavita25
Partner - Specialist
2015-08-28
08:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check the qvw.
Hope it helps you...
374 Views
terezagr
Partner - Creator III
2015-08-28
09:54 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Brilliant, thank you...not sure why I was immediately thinking about set analysis
374 Views