Forum Discussion
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...
See the attached version
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
See the attached version
- 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?- Hi Sergei
Many thanks for your example. Pivot tables would definitely be my preferred solution. Is it possible to do entirely with pivot tables based on the main table blue. Ultimately I need be able to select by date range.
