sort data After Refresh

[LearnMeExcel]

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

 

[scottsen]

Sorry, not quite getting your question/issue. If you literally mean the column and direction of the sort order of your pivot table... that shouldn't change, regardless of what you slice. But I get the feeling language is getting in the way and you mean something slightly different?

 

[LearnMeExcel]

lthank scott
my problem if i sort column form Z to A
and then change Sicer for area the sort deleted
and i reSort it again manual

 

[scottsen]

I've never seen that. Maybe post a workbook with a sampe to dropbox/onedrive/googledrive? I just tried it and couldn't make it... not stay sorted.