Author Topic: Return all value from column only for specific criteria  (Read 578 times)

Offline chiu2003

  • Full Member
  • ***
  • Join Date: Dec 2019
  • Posts: 6
  • Forum Citizenship: +1/-0
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.

 


       
Twittear