drom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 540
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
Hi and thanks in advance!
I am using a table with only 2 columns
In this table if I have most of the time many companies, but usually we work 90% of the time with 10-15 companies
This is why I have the Sort Order Column, If I want to see first CocaCola, and 2nd PEPSI I am gonna put close to CocaCola on rhe Sort to order column a number say eg: -50 and for PEPSI -25 and them I will sort this table in ascending order by this 2nd column
But with my 1st Columna has many companies I do not want to use data validations cells in my CRM's.
My problem
Ant idea how can I fix this??
Please I do not want to use FORM Controls
I am using a table with only 2 columns
- Columna A: COMPANY
- Can contain X companies (usually over 150)
- Column B Sort order
In this table if I have most of the time many companies, but usually we work 90% of the time with 10-15 companies
This is why I have the Sort Order Column, If I want to see first CocaCola, and 2nd PEPSI I am gonna put close to CocaCola on rhe Sort to order column a number say eg: -50 and for PEPSI -25 and them I will sort this table in ascending order by this 2nd column
- This works PERFECT when working with Data validation List cells attached to the Company Column
But with my 1st Columna has many companies I do not want to use data validations cells in my CRM's.
- So I use a pivot table with only 1 field ( the Company ) on the Filters position,
- I don't allow multiple selection and I add a Slicers as well
- If the end user selects >1 company using the slicers a conditional formatting shows RED colour on the Pivot table Filters Fileld
My problem
- Despite this pivot table has SORT in data source order the Filters keeps showing everything A-Z
- And I can Sort the country Slicer for this Pivot table in data source order
Ant idea how can I fix this??
Please I do not want to use FORM Controls