Need Help with Dropdown - Please Help :(

[Star1566]

Hello all,

I am in need of some assistance. I have a file where I created a report layout tab for the monthly rollup per supplier. I am trying to get the date field to display the raw data per month as well. I figured out how to display per supplier. When I currently select the date field it only gives me metric percentage in columns J-O, I also need that date field to display data specific to that month and supplier. I have attached a link for your reference The data s currently pulling from the OTD Data tab, thanks for any help I can receive


https://drive.google.com/open?id=1GQEzXDtWmJAkYwzJXNEc1_z9Ebrnpp16

 

[yellow_orange]

Please check file that i worked on - https://drive.google.com/file/d/1liduSvoTP2MnipjvW7mG4s2WD7AAoELM/view?usp=sharing

I used aggregate and small functions. please check Mike Girvin's video - https://www.youtube.com/watch?v=KPhvLMzXa_8&t=397s

 

[Star1566]

Thank you so much! This is exactly what I am looking for! I will check out the video as a reference!