Max Till Date

Question & Answer
,
1

Hi ,
I have requirement, Where I have below Scenorio,
Month - Product - Sales % - Highest Sales %
Jan’24 - A - 10 % - 10%
Feb’24 - A - 8% - 10%
Mar’24 - A - 20 % – 20 %
Apr’24 - A - 9 % – 20 %
May’24 - A - 30 % - 30 %

if apply filter for only month Apr’24, Its huld show max Sales as 20 % , if i selct Feb’24 it should say max sales as 10 %

How can i arrive this output

2

Hi @ramakrishna92

Please refer to the following and see if this helps your cause.

Regards,
Giri

1 Like
3

Hi @ramakrishna92,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @ramakrishna92,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!

5

I Got Solution for it with Date Hider

2 Likes