Forum Discussion

WillSmyth's avatar
WillSmyth
Copper Contributor
Jun 22, 2023
Solved

Pivot to track products that are predominantly sold to one customer

Hi We are looking to track items that are predominantly sold to a single customer. This is to reduce the risk of excess stock should the customer stop purchasing an item.    I have a data set show...
BI & Data Analysis
excel
Formulas and Functions
Macros and VBA
  • WillSmyth's avatar
    WillSmyth
    Copper Contributor
    Jun 22, 2023

    HansVogelaar Many thanks for your explanation and sample worksheet. I have been able to replicate on a small dataset but am having problems applying in main data set. My excel data is a table (from SQL feed). Would you be able to offer help with applying your solution to table data? Using either your sample data or my larger test data set https://bch4-my.sharepoint.com/:x:/g/personal/wsmyth_bch_eu_com/ES_Rh4E5F-NJr8bDeR38MG4B2AtlcrbsVwcVOu1PynFNQw?e=hGLf5c  

    Thanks 

    Willy

      • WillSmyth's avatar
        WillSmyth
        Copper Contributor
        Jun 28, 2023
        hans
        The SORT UNIQUE function appear to operate on the entire source table regardless of any filters that may be in place on the filter. If this expected behaviour? What is the solution - create a table based on the table with filters in place?

Resources