oliver_wonder
New Member
- Joined
- Sep 25, 2018
- Messages
- 3
Hi All,
<colgroup><col width="58" span="3" style="width:43pt"> </colgroup><tbody>
</tbody>
first i want to get the sum of each date, and find the maximum value on month,can i get the answer in one forumla by using just like Max(sum[value]). thank you very much.
Date | Month | Value |
1/1/2018 | Jan | 2 |
2/1/2018 | Jan | 4 |
3/1/2018 | Jan | 8 |
1/1/2018 | Jan | 1 |
2/1/2018 | Jan | 3 |
3/1/2018 | Jan | 5 |
1/1/2018 | Jan | 7 |
2/1/2018 | Jan | 8 |
3/1/2018 | Jan | 9 |
<colgroup><col width="58" span="3" style="width:43pt"> </colgroup><tbody>
</tbody>
first i want to get the sum of each date, and find the maximum value on month,can i get the answer in one forumla by using just like Max(sum[value]). thank you very much.