I have a custom dimension on Week I want to use the data from previous Week Suggest me the solution
Thanks in advance
One of the possible solutions would be a reference to previous week via lookup.
Let's say you crated line item "Previous week" in "TECH - weeks" module.
Then you can write a formula X=Y[lookup: 'TECH - weeks'.Previous week]. But you can't refer to the same line item since it's gonna be circular reference.
Also you may consider using CUMULATE().
If none of these solution helps, can you describe the details of the problem you're trying to solve?