Ya definately rohan, you need to use filter instead of parameter. because parameter require manual refresh when new data items comes in.
And, also with the filter we can create YTD calculations as well as default sort to latest month.
Your workbook seems very congested, if possible please post simple workbook with you requirement/question so that anyone can look into it.
Hope this helps!
Thanks for reply Nikunj Bhardava.
Please check the attached sample workbook on superstore data.
In this workbook there are two sheets one is at YTD level and one is at Monthly level. Client is expecting parameter month need to change as and when data is available for latest month(Dynamic parameter), is it possible?
Or can we use order date filter instead of parameter so that output will be the same as parameter functionality and default month will be the latest month?
Superstore_parameter.twbx 389.1 KB