2 Replies Latest reply on Nov 12, 2017 9:58 AM by Adhi shankar

    Not able to show multiple dimension names instead of dimension values in rows in Tableau Worksheet

    Adhi shankar

      Hi,

       

      I have eight dimension as Promo ID1, Promo ID2,Promo ID3,Promo ID4 to Promo ID8 andd have measures as No of leads received ,No of Leads expiring.

       

      When i drag the all dimension into rows self , i seeing all the values of the dimension values but i want to see only the name of the dimension row by row and measures in column self.

       

      I tried creating diemension calculated field for Promo1 and it worked but not for other promo ids as expected.

       

      Attaching the worksheet Promos.jpg screenshot.

       

      I wanted to change as below .

       

         

                             No of Leads         No of Leads Expiring
      PromoID1        3535
      PromoID2        6635
      PromoID3       1562
      PromoID1
      PromoID3
      PromoID4
      PromoID5
      PromoID6
      PromoID7

       

       

      I tried the below option but it did not work as expected like above format.

       

      Formula i used in calc field

      IF [Promo Id 1]!='' THEN 'Promotion 1' END

      IF [Promo Id 2]!='' THEN 'Promotion 2' END ..etc

       

       

      Please help me how to do it worksheet.

       

      attached the screenshot(not working promo.jpg) what i  tried also.