LearnMeExcel
Well-known Member
- Joined
- Aug 11, 2009
- Messages
- 746
- Office Version
- 365
- 2021
- Platform
- Windows
how i can create growth Percentage for year to year
i put year inColumn Labl
in my data thers many year from 2000 to 2014
i want when i select 2013 and 2014
i use this muesure
=DIVIDE(CALCULATE([Total Sales], SalesT [InYear]=2014),CALCULATE([Total Sales],SalesT[InYear]=2013))-1
but this is ony for 2014
if i select by slicr from 2011 to 2014
to give me % for every year from the previous one
i hope my idea is clear
thax
i put year inColumn Labl
in my data thers many year from 2000 to 2014
i want when i select 2013 and 2014
i use this muesure
=DIVIDE(CALCULATE([Total Sales], SalesT [InYear]=2014),CALCULATE([Total Sales],SalesT[InYear]=2013))-1
but this is ony for 2014
if i select by slicr from 2011 to 2014
to give me % for every year from the previous one
i hope my idea is clear
thax
Last edited: