Forum Discussion
Helper IIILatest month data not showing
Helper IIIHi Ashish,
Please find the sample raw data and expect
ed result. I want to show latest month (default ) top 3 names.. if user required they can select months in slicer.
| Name | Sales | MonthDate |
| AAA1 | 125453 | 01/01/2023 |
| DDD | 18116 | 01/02/2023 |
| BB1 | 15373 | 01/01/2023 |
| AAA1 | 15359 | 01/03/2023 |
| CCC | 14647 | 01/02/2023 |
| FFFF | 13736 | 01/03/2023 |
| DDD | 13262 | 01/01/2023 |
| RRR | 12784 | 01/03/2023 |
| RRR | 12771 | 01/02/2023 |
| TTT | 12761 | 01/03/2023 |
| EEE | 12533 | 01/01/2023 |
| AAA1 | 12209 | 01/04/2023 |
| EEE | 11697 | 01/02/2023 |
| RRR | 11583 | 01/04/2023 |
| TTT | 11071 | 01/04/2023 |
| EEE | 9990 | 01/04/2023 |
| FFFF | 9925 | 01/01/2023 |
| DDD | 9810 | 01/05/2023 |
| FFFF | 9716 | 01/05/2023 |
| TTT | 7934 | 01/05/2023 |
| YYY | 7723 | 01/05/2023 |
| EEE | 7440 | 01/05/2023 |
Expected as default resulrt to be :
Thanks for your support.
Super UserI am still not clear about what you want but here's a start. Download the attached file.
Hope this helps.
- MSuser5
Hi Ashish_Mathur ,
Thanks for the update, As same result i want to show only latest month data in the table chart if user required to see any other month then they will select from month sclier.
So how to show default latest month only.
Thanks,
- Ashish_Mathur
You are welcome. It is easier to just select the latest or any other month in the slicer.
- MSuser5
Ashish_Mathur - Can't we show latest month as default without selecting from slicer.?