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

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

  • @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.

  • 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

     

  • @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_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?