L2 Sprint 1 - Lesson 1.5.3.1 Create Filter and Saved View for DAT01 Module

Candy
Candy
in Academy Discussions

Hello,

I'm stuck on below task. I'm just confuse on the part where Filter is equal to checked?

Candy_0-1616485387968.png

Below is what I have done.

Candy_1-1616485478904.png

End Result

Candy_2-1616485543587.png

 

Can anyone confirm if what I've done is correct?

Much appreciated. 😊

Candy

Comments

  • Misbah
    Misbah

    @Candy 

     

    In your first Screenshot instead of applying Beginning Inventory greater than 0 as a filter use Boolean formatted line item that is already available in your  DAT01 module and apply that as a filter.

  • juanacevedo
    juanacevedo

    Hi @Misbah -  I am having some issue trying to apply the filter in this point as well. 

     

    Below the image Im getting, I cant find a button to confirm the filter so is not getting applied. 

     

    Can you help?

     

    Thanks 

     

     

     

    juanacevedo_0-1631108743354.png

     

  • Misbah
    Misbah

    @juanacevedo 

     

    In your DAT01 module, if you do not have a Filter line item then create it.

     

    Filter Line item (Boolean formatted) = Beginning Inventory<>0

     

    Then go to the filter, Pick the line item Filter in the below screenshot

    Misbah_0-1631184122552.png

     

    Misbah

     

  • Yogitha
    Yogitha

    Yogitha_0-1663996752968.png

    The filter needs to work on one axis, so pivot the module view: 

    • Columns: Line Items 
    • Rows: SKU Flat list, s Location Flat: Distribution Center? list

    Apply a filter to display only product SKU inventory values not equal to zero:

    • Create a rule for the nested dimensions (SKU Flat and s Location Flat: Distribution Center?) to show values where DAT01 Beginning Inventory: Filter is equal to checked.
    • Enable the filter.

     

    Is this all to do with the activity?

    Or anything else ?

    What to do with : ?

    Apply a filter to display only product SKU inventory values not equal to zero:

    • Create a rule for the nested dimensions (SKU Flat and s Location Flat: Distribution Center?) to show values where DAT01 Beginning Inventory: Filter is equal to checked.
    • Enable the filter.

    Can u check the numbers also nd let me know if its right?

Categories