Below are the required output in tableau:-
Case First Filter 2nd Filter (Required Output based on first
1 All February 2018 (Default Selected Month) Sandeep Kumar January 2018 Gaurav Dureja December 2017 Shruti Gupta November 2017 October 2017 2 Sandeep Kumar December 2017 (Default Selected Month) November 2017 October 2017 3 Gaurav Dureja January 2018 (Default Selected Month) December 2017 November 2017 4 Shruti Gupta February 2018 (Default Selected Month) January 2018 December 2017 November 2017
Hi Sandeep Kumar,
There is no direct solution for this as far i know. But I have tried something here.Please find the calculations and report images.
Please mark it as helped if you got the answer.