Pivot's Dimensional Computations

The example shows how to compute custom dimensional (row, column, etc) values

Sales		2003									2004											Yearly Difference	Total
Sales		March	April	May	June	July	September	November	Half Year Difference	Total	January	February	May	July	August	September	October	November	December	Half Year Difference	Total	Yearly Difference	Total
AV Stores, Co.	Classic Cars	$25,306	-	-	-	-	-	-	$-25,306	$25,306	-	-	-	-	-	-	$16,414	$18,324	-	$34,738	$34,738	$9,432	$60,044
	Ships	-	-	-	-	-	-	-	$0	-	-	-	-	-	-	-	$19,186	-	-	$19,186	$19,186	$19,186	$19,186
	Trains	-	-	-	-	-	-	-	$0	-	-	-	-	-	-	-	$7,874	-	-	$7,874	$7,874	$7,874	$7,874
	Vintage Cars	$23,120	-	-	-	-	-	-	$-23,120	$23,120	-	-	-	-	-	-	$9,352	$28,835	-	$38,187	$38,187	$15,067	$61,307
	Total	$48,426	-	-	-	-	-	-	$-48,426	$48,426	-	-	-	-	-	-	$52,825	$47,159	-	$99,984	$99,984	$51,559	$148,410
Alpha Cognac	Classic Cars	-	-	-	-	$14,233	-	$3,166	$17,399	$17,399	-	-	-	-	-	-	-	-	-	$0	-	$-17,399	$17,399
	Planes	-	-	-	-	-	-	$16,555	$16,555	$16,555	-	-	-	-	-	-	-	-	-	$0	-	$-16,555	$16,555
	Ships	-	-	-	-	-	-	$5,847	$5,847	$5,847	-	-	-	-	-	-	-	-	-	$0	-	$-5,847	$5,847
	Vintage Cars	-	-	-	-	-	-	$8,250	$8,250	$8,250	-	-	-	-	-	-	-	-	-	$0	-	$-8,250	$8,250
	Total	-	-	-	-	$14,233	-	$33,818	$48,051	$48,051	-	-	-	-	-	-	-	-	-	$0	-	$-48,051	$48,051
Amica Models & Co.	Classic Cars	-	-	-	-	-	-	-	$0	-	-	-	-	-	$6,995	$19,429	-	-	-	$26,424	$26,424	$26,424	$26,424
	Ships	-	-	-	-	-	-	-	$0	-	-	-	-	-	-	$6,251	-	-	-	$6,251	$6,251	$6,251	$6,251
	Trains	-	-	-	-	-	-	-	$0	-	-	-	-	-	-	$2,019	-	-	-	$2,019	$2,019	$2,019	$2,019
	Trucks and Buses	-	-	-	-	-	-	-	$0	-	-	-	-	-	$2,352	-	-	-	-	$2,352	$2,352	$2,352	$2,352
	Vintage Cars	-	-	-	-	-	-	-	$0	-	-	-	-	-	$38,952	$6,225	-	-	-	$45,177	$45,177	$45,177	$45,177
	Total	-	-	-	-	-	-	-	$0	-	-	-	-	-	$48,299	$33,924	-	-	-	$82,223	$82,223	$82,223	$82,223
Anna's Decorations, Ltd	Classic Cars	-	-	-	-	-	$38,707	$22,145	$60,853	$60,853	-	-	-	-	-	-	-	-	-	$0	-	$-60,853	$60,853
	Motorcycles	-	-	-	-	-	-	$16,402	$16,402	$16,402	-	-	-	-	-	-	-	-	-	$0	-	$-16,402	$16,402
	Vintage Cars	-	-	-	-	-	$2,848	-	$2,848	$2,848	-	-	-	-	-	-	-	-	-	$0	-	$-2,848	$2,848
	Total	-	-	-	-	-	$41,555	$38,547	$80,102	$80,102	-	-	-	-	-	-	-	-	-	$0	-	$-80,102	$80,102
Atelier graphique	Classic Cars	-	-	$14,571	-	-	-	-	$-14,571	$14,571	-	-	-	-	-	-	-	-	-	$0	-	$-14,571	$14,571
	Motorcycles	-	-	-	-	-	-	-	$0	-	-	-	-	-	-	$6,067	-	-	-	$6,067	$6,067	$6,067	$6,067
	Vintage Cars	-	-	-	-	-	-	-	$0	-	-	-	-	-	-	-	-	$1,676	-	$1,676	$1,676	$1,676	$1,676
	Total	-	-	$14,571	-	-	-	-	$-14,571	$14,571	-	-	-	-	-	$6,067	-	$1,676	-	$7,743	$7,743	$-6,829	$22,314
Australian Collectables, Ltd	Classic Cars	-	-	-	-	-	-	$1,657	$1,657	$1,657	-	-	-	$9,415	-	-	-	-	-	$9,415	$9,415	$7,758	$11,072
	Vintage Cars	-	-	-	-	-	-	$33,849	$33,849	$33,849	-	-	-	-	-	-	-	-	-	$0	-	$-33,849	$33,849
	Total	-	-	-	-	-	-	$35,506	$35,506	$35,506	-	-	-	$9,415	-	-	-	-	-	$9,415	$9,415	$-26,091	$44,921
Australian Collectors, Co.	Classic Cars	-	-	-	-	-	-	-	$0	-	-	-	-	-	-	-	-	$48,010	-	$48,010	$48,010	$48,010	$48,010
	Motorcycles	-	$21,815	-	-	-	-	-	$-21,815	$21,815	-	$26,696	-	-	-	-	-	$1,503	-	$-25,193	$28,200	$6,385	$50,014
	Planes	-	$20,023	-	-	-	-	-	$-20,023	$20,023	-	$15,182	-	-	-	-	-	-	-	$-15,182	$15,182	$-4,841	$35,205
	Trucks and Buses	-	-	-	-	-	-	-	$0	-	-	-	-	-	-	-	-	$16,327	-	$16,327	$16,327	$16,327	$16,327
	Vintage Cars	-	$4,026	$7,565	-	-	-	-	$-11,592	$11,592	-	$3,016	-	-	-	-	-	$16,422	-	$13,405	$19,438	$7,846	$31,029
	Total	-	$45,864	$7,565	-	-	-	-	$-53,429	$53,429	-	$44,895	-	-	-	-	-	$82,261	-	$37,366	$127,156	$73,727	$180,585
Australian Gift Network, Co	Classic Cars	-	-	-	-	-	$7,935	$7,068	$15,002	$15,002	-	-	-	-	-	-	-	-	-	$0	-	$-15,002	$15,002
	Trains	-	-	-	-	-	$1,887	-	$1,887	$1,887	-	-	-	-	-	-	-	-	-	$0	-	$-1,887	$1,887
	Trucks and Buses	-	-	-	-	-	-	$10,086	$10,086	$10,086	-	-	-	-	-	-	-	-	-	$0	-	$-10,086	$10,086
	Vintage Cars	-	-	-	-	-	-	$6,783	$6,783	$6,783	-	-	-	-	-	-	-	-	-	$0	-	$-6,783	$6,783
	Total	-	-	-	-	-	$9,821	$23,937	$33,758	$33,758	-	-	-	-	-	-	-	-	-	$0	-	$-33,758	$33,758
Auto AssociÃƒÂ©s & Cie.	Classic Cars	-	-	-	-	-	-	-	$0	-	-	-	-	-	-	-	$12,704	-	-	$12,704	$12,704	$12,704	$12,704
	Trucks and Buses	-	-	-	-	-	-	-	$0	-	-	$5,759	-	-	-	-	$11,353	-	-	$5,593	$17,112	$17,112	$17,112
	Vintage Cars	-	-	-	-	-	-	-	$0	-	-	-	-	-	-	-	$29,060	-	-	$29,060	$29,060	$29,060	$29,060
	Total	-	-	-	-	-	-	-	$0	-	-	$5,759	-	-	-	-	$53,117	-	-	$47,358	$58,876	$58,876	$58,876
Auto Canal+ Petit	Classic Cars	-	-	-	-	-	-	-	$0	-	$26,091	-	$13,431	-	-	-	-	-	-	$-39,522	$39,522	$39,522	$39,522
	Motorcycles	-	-	-	-	-	-	-	$0	-	$23,074	-	$11,650	-	-	-	-	-	-	$-34,724	$34,724	$34,724	$34,724
	Total	-	-	-	-	-	-	-	$0	-	$49,165	-	$25,081	-	-	-	-	-	-	$-74,246	$74,246	$74,246	$74,246
Auto-Moto Classics Inc.	Planes	-	-	-	-	-	-	-	$0	-	-	-	-	-	-	-	-	-	$7,931	$7,931	$7,931	$7,931	$7,931
	Ships	-	-	-	$2,753	-	-	-	$-2,753	$2,753	-	-	-	-	-	-	-	-	$1,728	$1,728	$1,728	$-1,025	$4,481
	Vintage Cars	-	-	-	$3,284	-	-	-	$-3,284	$3,284	-	-	-	-	-	$5,859	-	-	-	$5,859	$5,859	$2,574	$9,143
	Total	-	-	-	$6,037	-	-	-	$-6,037	$6,037	-	-	-	-	-	$5,859	-	-	$9,659	$15,517	$15,517	$9,480	$21,554
Total		$48,426	$45,864	$22,137	$6,037	$14,233	$51,376	$131,808	$74,953	$319,880	$49,165	$50,654	$25,081	$9,415	$48,299	$45,850	$105,942	$131,096	$9,659	$225,361	$475,161	$155,282	$795,041

Pivot's Dimensional Computations

Description