BASE YEAR FORMULA

[#1]

Hello everybody:

I'm trying to compare everi month sale with a single month (2013-02) to get de % of variation.

Can anybody recomend a formula to do this?

Thanks!

SUC_Descripcion	FormaPago	PeriodoFactura	2013-02	2013-03	2013-04	2013-05
1	Credito		6.098	10.308	5.825	5.862
1	Debito		6.180	5.680	4.363	4.534
1	Efectivo		12.628	19.059	8.664	15.739
1	Total		24.905	35.047	18.851	26.135
2	Credito		8.265	17.474	14.331	13.034
2	Debito		7.182	10.094	9.369	10.845
2	Efectivo		17.223	48.588	36.368	40.749
2	Total		32.670	76.155	60.068	64.628
Total			57.575	111.202	78.919	90.762
SUC_Descripcion	FormaPago	PeriodoFactura	2013-02	2013-03	2013-04	2013-05
1	Credito		6.098	6.098	6.098	6.098
1	Debito		6.180	6.180	6.180	6.180
1	Efectivo		12.628	12.628	12.628	12.628
1	Total		24.905	24.905	24.905	24.905
2	Credito		8.265	8.265	8.265	8.265
2	Debito		7.182	7.182	7.182	7.182
2	Efectivo		17.223	17.223	17.223	17.223
2	Total		32.670	32.670	32.670	32.670
Total			57.575	57.575	57.575	57.575
SUC_Descripcion	FormaPago	PeriodoFactura	2013-02	2013-03	2013-04	2013-05
1	Credito		100%	59%	105%	104%
1	Debito		100%	109%	142%	136%
1	Efectivo		100%	66%	146%	80%
1	Total		100%	71%	132%	95%
2	Credito		100%	47%	58%	63%
2	Debito		100%	71%	77%	66%
2	Efectivo		100%	35%	47%	42%
2	Total		100%	43%	54%	51%
Total			100%	52%	73%	63%

Hola:

Necesito ayuda para generar una tabla pivotante que calcule la variación mensual respecto a un período (2013-02)

Alguna recomendación?
Gracias!

[MayilVahanan]

HI

Try like this

=Sum({<período ={'2013-02'}>}Sales)/ Sum(Sales)