omkarvamsi
Creator
2016-04-26
03:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to Get Static maximum Sales "YEAR" by aggregating year's sales?
Hi,
I have got maximum aggregated sale's by year using below function in a Text box.
// =FirstSortedValue(year, -aggr(sum(sales), year))
when i'm selecting year in a list box,the value in text box is also changing(i.e YEAR).
But i Want the value in text box should not change(i.e maximum sale's YEAR).
455 Views
1 Solution
Accepted Solutions
sunny_talwar
MVP
2016-04-26
03:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be try this:
=FirstSortedValue({<year>}year, -Aggr(Sum({<year>}sales), year))
3 Replies
sunny_talwar
MVP
2016-04-26
03:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be try this:
=FirstSortedValue({<year>}year, -Aggr(Sum({<year>}sales), year))
omkarvamsi
Creator
2016-04-27
02:00 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you sunny,it worked
332 Views
sunny_talwar
MVP
2016-04-27
11:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Awesome. If everything is resolved, please close this thread by marking the correct answer
332 Views