Return all value from column only for specific criteria

[chiu2003]

Hi all,

I have attached excel report that retrieving for product information. (Remove price information)
https://www.dropbox.com/scl/fi/y3l10loru9krv49lswukm/Europe-Inventory-Detail-Ending-Trend-Past-12-Months-Bi-Weekly.xlsx?dl=0&rlkey=itruzahips2vp343m0mnj88oe

Is it possible that to do so:

• Only export "Spare Part" data (Location Type Column) for UK CORPORATE (BI Business Unit ID column)
• But need to export all data for other BI Business Unit?

Many Thanks.