Level 2 sprint 3 Build Distribution Summary Dashboard

Highlighted
Contributor

Level 2 sprint 3 Build Distribution Summary Dashboard

In the activity following instructions were given, where I am confused with the highlighted one

kunal_311_0-1597232144254.png

1) Applying a filter to DAT01 Beginning Inv -  I am confused as in how to show which Product SKU is stored at which distribution center, what i thought was in the line item Nutzo bar EN SKU & New york as distribution center should be equal. is that not correct?

kunal_311_1-1597232350325.png

2) SYS 07 & 08 want to show label of selected DC & Product. but I am confused about how to acheive that. As i am not seeing any option in DB to enable that

 

kunal_311_2-1597232513361.png

 

 

 

 

6 REPLIES 6
Highlighted
Master Anaplanner/Community Boss

Re: Level 2 sprint 3 Build Distribution Summary Dashboard

@kunal_311 

 

Pivot your SYS07 module and bring your Line items to Rows and Distribution Center to Pages

Pivot your SYS08 module and bring your Line items to Rows and SKUs to Pages

 

That should give you what you want

 

Hope that helps

Misbah

Highlighted
Contributor

Re: Level 2 sprint 3 Build Distribution Summary Dashboard

Yupp got this one
Highlighted
Master Anaplanner/Community Boss

Re: Level 2 sprint 3 Build Distribution Summary Dashboard

@kunal_311 

 

On Point 1 - I think you can pivot it and bring SKUs and DC in rows and Line items in Columns and apply filter on SKU/DC combination and not on line items.

 

Note: It's been long since I have taken this course

Highlighted
Contributor

Re: Level 2 sprint 3 Build Distribution Summary Dashboard

Hi @Misbah 

 

Pivot part understood, Coming on formula, still not able to encode it

 

The Excercise statement said - Filter to only show which product SKUs are stored at each Distribution Center 

 

which means filter needs to set on the mapping of product SKU & DC. which I tried implementing filtering on SYS08 module as it has both DC as well as product details , but not getting the result, can you please help me with the understanding.

Highlighted
Contributor

Re: Level 2 sprint 3 Build Distribution Summary Dashboard

@Misbah 

 

I was able to figure it out. Thank You for your guidance.

Highlighted
New Contributor

Re: Level 2 sprint 3 Build Distribution Summary Dashboard

I'm still stuck on this exact spot...any tips that helped you get past the hurdle? I'm now headed towards needing to make an additional line item, which doesn't feel right.

Thanks,

-R