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

    distinct Dimension Value in Expression

    Praveen Kumar Konda

      Hi,

       

      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.

       

      Regards,

      PK