LearnMeExcel
Well-known Member
- Joined
- Aug 11, 2009
- Messages
- 746
- Office Version
- 365
- 2021
- Platform
- Windows
hi
in my powerpivot Report, i have many Year in Column area, and i have 7 slicer horizental and vertical,
i sort my Report at Last Year, for example
years in my data from 1995 to 2014
if i select 2013 Vs 2014 i sort data on 2014
when i slcie years from 2005 to 2014 and slice another Product, my Report change the sort
it mans i will make a new sort on last year 2014
how i can keep it, while i am changing my Critreia
Note : most my reoprt depends on 2014
many thanks
in my powerpivot Report, i have many Year in Column area, and i have 7 slicer horizental and vertical,
i sort my Report at Last Year, for example
years in my data from 1995 to 2014
if i select 2013 Vs 2014 i sort data on 2014
when i slcie years from 2005 to 2014 and slice another Product, my Report change the sort
it mans i will make a new sort on last year 2014
how i can keep it, while i am changing my Critreia
Note : most my reoprt depends on 2014
many thanks