3 Replies Latest reply on Nov 21, 2018 10:40 AM by Anupam Kamal

# Fixed LOD for a dimension

Hi Guys,

So i am stuck on this for quite some while. If someone can help me accomplish this dimension, would be very thankful. Here's the issue: I want  2 calculated dimensions which have the values like the field 1 and 2(grayed columns), They should compute values by fixing client ID and item, then one picks up the region value based on '-1' for that ID and shows it on both -1 and 1 line. Similarly the second column, picks the region value against price bucket '1' for that ID and shows it on both the -1 and 1 line.

Would highly appreciate any help.

Thanks.

• ###### 1. Re: Fixed LOD for a dimension

Anupam,

I think it is

Calculation 1 : {Fixed ID, Item: MAX(If [Price Bucket]=1 then [Region] END)}

Calculation 2 : {Fixed ID, Item: MAX(If [Price Bucket]=-1 then [Region] END)}

You can then convert these two fields as dimensions to give desired result.

1 of 1 people found this helpful
• ###### 2. Re: Fixed LOD for a dimension

Calc1;

{FIXED ID:MAX(IF{FIXED ID:MIN([Price Bucket])}=[Price Bucket] THEN Region END)}

Calc2;

{FIXED ID:MAX(IF{FIXED ID:MAX([Price Bucket])}=[Price Bucket] THEN Region END)} Thanks

Deepak

If it Helps, Pl Mark it Helpful and CORRECT to Close Thread

1 of 1 people found this helpful
• ###### 3. Re: Fixed LOD for a dimension

Thanks a lot Deepak and Maneesh. I should be able to figure it out now.

Appreciate the quick help.

Anupam