I hope I understand your requirement, below find attached workbook with my solution.
Below is the screenshot of steps and results.
Update: forget to mention, I made changes to % calculation as well
Hope this could help
Tableau_LAS_MIS_POC_v1.twbx 1.8 MB
This is exactly what I was looking for, Really appreciate your help thanks. I was thinking, since I have Already used LOD expression in Calculation LatestBooksize_RM, Latest_Booksize_Category_% would not Require using LOD again. I Still need to understand LOD expressions I guess.
I have one more follow up Question.
I am trying to calculate Difference of LatestBooksize_RM and Booksize value selected by Parameter control which is as follows:
User inputs number of days and I have to calculate date difference from Latest date and accordingly calculate Difference in Booksize.
Marked in red is the same calculation used to calculate LatestBooksize_RM.
I am able to get Difference Date by taking number of days as input in below screenshot.
( variable marked by red arrow is just to test date difference calculation).But I am not able to get the difference in Booksize.I am not sure what I am doing wrong.