1 Reply Latest reply: Aug 28, 2015 4:47 PM by John McTurnan RSS

    distinct Dimension Value in Expression

    Praveen Kumar Konda



      I am looking for a way to display distinct values in a expression for a particular dimension.

      Can we do this?


      I have records like


      Country   State  City

      INDIA     AP      Hyderabad

      INDIA     MH     Mumbai

      USA       CA      San Fransisco

      UK          HS     London



      I want to display this in a table but India should not repeat....it should show blank like a pivot but i want to use table only..

      Please help me.