cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

Hello,

I have a requirement to define restricted measures that show values for Last week w.r.t to the week entered in the prompt. I can derive the last week from another view using a Derive Value variable, but I cannot use it in the filter for a Restricted Measure. Dynamic Default is not an option as it's derived before the prompt. Is there a way to work around this and somehow achieve the behavior of a Derive Value variable used inside a restricted measure?

 

 

View Entire Topic
rushikesh_rajput
Explorer
0 Likes

Step 1 :
rushikesh_rajput_0-1746021684761.png

Step 2 :
rushikesh_rajput_1-1746021997725.png