12.4.1 Conditional Format

jessieg1906
jessieg1906
in Academy and learning discussions

I feel like this is a easy fix but haven't found the right solution. it's not mirroring what the example should be looking like since the departments are in a different place. and since employees need to be under departments, im not sure where to go from here

Tagged:

Comments

  • Pooja
    Pooja

    Hey,

     

    Can you provide more details on this?

    I might have understood your question wrongly, if you want to see employees under department simply you have to select "before" by clicking the group icon in grid view like below.

    Pooja_0-1652765678024.png

     

     

    Thanks

    Pooja

  • Neeharika
    Neeharika

    Hi jessieg1906,

    Here is the step guide for you. Please refer and let me know if still stuck.

  • rohan.suratwale
    rohan.suratwale

    Hi @jessieg1906 ,

    If you want to arrange your hierarchy as mentioned in the screenshot , you can simply click on the icon present on the right hand side of "Pivot" Icon. (Highlighted in below screenshot)

    rohansuratwale_0-1652779981947.png

    and then select the option to group the totals at Start.


    rohansuratwale_1-1652780050598.png

    This is sort the arrangement of list items as shown in the example.
    After the sort you can apply the required Conditional Formatting based on the values suggested.

     

    feel free to reach out if you need more assistance.
    --ROHAN

  • jessieg1906
    jessieg1906

    nothing changed unfortunately. I have screenshots posted of what I have. A is what the example is supposed to look like, B is what i have

  • jessieg1906
    jessieg1906

    Didn't work for some reason. It grouped them but doesnt mirror the example. A is the example, B is what I have

  • rohan.suratwale
    rohan.suratwale

    Hi @jessieg1906 ,

    i have noticed that in the example you have uploaded as picture "A" seems to be having a sort assigned to it
    please click on the red marked icon on your module view to apply the same sort condition as they have applied,
    by the look of it , it seems to be sorted in descending order.

    rohansuratwale_0-1652793993668.png

     

    --ROHAN 

     

  • jessieg1906
    jessieg1906

    oh man, that worked and almost have it done. it has my headcount for 12 but its supposed to be 1, going off the example. so there must be a data error going on correct?

  • rohan.suratwale
    rohan.suratwale

    Hi @jessieg1906 ,

    Can you please share what formula you have applied on that line item,
    like in the example you have attached they have used the highlighted formula.

    rohansuratwale_1-1652794832690.png

    hope that helps.

    --ROHAN

     

  • TimWard70
    TimWard70

    Check your time summary setting - for this it will likely need to be closing balance rather than sum

  • jessieg1906
    jessieg1906
    That was it! thanks guys! That really rattled be for a solid two days
  • jessieg1906
    jessieg1906
    We got it right! Thanks for the help and quick responses!

Categories