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

    Fixed LOD for a dimension

    Anupam Kamal

      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.