Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Help Me with How to Keep Inside +/- Box Data in Table format

Hi Team ,   i have Date , Intime ,Outtime, Total hours  in sub Row , i want to keep it this in table formate like Date in one Box , Intime in another box and out time  in different box but in same ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  Anonymous ,

     

    Here are the steps you can follow:

    1. Select [Date] – Split Column -- Split Column by Delimiter.

    Select or enter delimiter -- Custom “|”.

    Split at – Each occurrence of the delimiter.

    2. Perform the following operations on [Date.2], [Date.3], and [Date.4]:

    Split Column -- Split Column by Delimiter.

    Select or enter delimiter – Colon

    Split at – Left – most delimiter.

    3. Select [Date2.1], [Date3.1], [Date4.1] – Remove Column.

    4. Modification of column names

    5. Row headers – turn off -- +/- icons and Stepped layout.

    6. Turn off – Column subtotals and Row subtotals.

    7. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly