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.