1 Reply Latest reply on Nov 29, 2018 10:42 PM by Ombir Rathee

    Pivot formation

    Jaydeep basu

      Hi,

      Please refer the 2 screenshot enclosed.

      > 'LTN pivot formatting issue.jpg' is how I have the data

      > I want the 'LTN pivot formatting issue.jpg' to be shown as 'result.jpg'

       

      what steps I need to do to convert the view 'Active Directory exits', 'Epo Exists', 'Spider Exists' and 'Scan Tool Exists'  into 'result' which denotes true as tick and false as cross under 'Exist in tool' field which contains 'AD/SCCM/ePO/Spider in all rows.

       

      also enclosed a sample data 'Demo Tableau.xlsx'.