Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have data like below.
Date | Month | Value |
1-Jan-17 | Jan | 2 |
2-Jan-17 | Jan | 3 |
3-Jan-17 | Jan | 4 |
4-Jan-17 | Jan | 5 |
2-Feb-17 | Feb | 3 |
3-Feb-17 | Feb | 2 |
4-Feb-17 | Feb | 4 |
5-Feb-17 | Feb | 5 |
1-Mar-17 | Mar | 8 |
2-Mar-17 | Mar | 2 |
3-Mar-17 | Mar | 1 |
4-Mar-17 | Mar | 4 |
from above table i need the max value of each month and the date of the max value of the month.
output table is below:
Month | Max Value | Date |
Jan | 5 | 4-Jan-17 |
Feb | 5 | 5-Feb-17 |
Mar | 8 | 1-Mar-17 |
Please suggest me.
May be this
Dimension
Month
Expression
Max(Value)
FirstSortedValue(Date, -Value)
May be this
Dimension
Month
Expression
Max(Value)
FirstSortedValue(Date, -Value)