I have enabled the week dimension in time range settings. This is the setting windows.
The hierarchy looks something like this -
I have updated the hierarchy and normalized but the aggregation function is not working as expected. When we are trying to roll up from week to fiscal year the total is coming wrong.(I have highlighted the cells).
In the above screenshot, the first table is at Fiscal year level and the second table is at week level. The expected value in highlighted cell of first stable should be 66361 but it is showing 99737.
Kindly advise how to resolve this issue.
