Set expression to show value regardless particular dimension selection

[coloful_architect]

Hi guys,

I am working on showing products' prices by using set expression. Wanan block some dimensions. So whatever some dimension changes, the price remain the same. 

I searched some posts and got this formula , but maybe I miss something it does not work.

What I wanna do is that the contract price stays the same in disregard of changes on Rep Name, Full Customer Name and System name.

avg({1<Month = {"$(=Max(Month))"},[Rep Name]=,[Full Customer Name]=,[System Name]=>} [Contract Price])

[tresesco · Accepted solution]

Hello @coloful_architect , 🙂

You might need to include those disregarded dimensions in max() as well, like:

avg({1<Month = {"$(=Max( {<[Rep Name]=,[Full Customer Name]=,[System Name]>}Month))"},[Rep Name]=,[Full Customer Name]=,[System Name]=>} [Contract Price])

[coloful_architect]

Hi tresesco, 

mind if elaborate a bit more for what this MAX 's functionality is ?

[coloful_architect]

and by any chance there is another way like only keep those fixed dimension I want? 

I actually only want to lock two dimensions , let's say [Lock Field A] and [Lock Field B]

if it is possible, would you please share the set expression template with it?  still for contract price with max month?

Really appreciate it.