Straight Table with Variances

[rido1421]

Hi There

I would like to create a Table with a variance between the previous day and the Current day.

What could I use in the set analysis to achieve this variance and variance Percentage?

Date	Sales Amount	Variance	Variance%
20150701	10000	0	0%
20150702	12000	2000	20%
20150703	9000	-3000	-25%
20150704	5000	-4000	-44%
20150705	15000	10000	200%
20150706	3000	-12000	-80%
20150707	18000	15000	500%

Thank you

[tresesco · Accepted solution]

PFA

[rido1421]

WOW! Thanks

[Kushal_Chawda]

Please find the attached

[ankitbisht01]

1.Expression 1 = sum[(Sales Amount])

2. expression 2 =sum([Sales Amount])- Above([Sales Amount],1)

3. Expression 3 = = (sum([Sales Amount])-Above([Sales Amount]))/Above([Sales Amount])

PFA

Regards

Ankit Bisht