Thanks for your response!
By setting Sub Category filter to : MP, MU,
The expected output for "Percent of Total - Running Week" is as following : ( Row 41 from the Excel sheet : Sheet1)
Percent of Total - Running Week = [Running 4 Week Total - Selected Sum] / [Running 4 Week Total - Total]
With the above selection, I am getting values right from week 35 but not before that ( I have purposefully blanked out the values for the first three weeks in the view where there is not enough data)
Would you be able to help with that
The issue I was facing was with the missing data for certain weeks for the Subcategories.
To get around the issue I had to add zeroes where ever there is no data for Subcategories during certain weeks.
So, my dataset now has data for every week under each Sub-Category.