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

Candy
Contributor

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

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Misbah
Moderator

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

View solution in original post

4 REPLIES 4
Misbah
Moderator

@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
Occasional Contributor

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
Moderator

@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
Frequent Contributor

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?