Calculate average based upon the Dimensions values.

[Anonymous]

Hi All,

I have a source dataset like as,

  Source:

Category	Date	Value_v1
A	01/01/2017AM	30518
A	01/01/2017PM	28484
A	01/02/2017AM	26806
A	01/02/2017PM	23227
C	01/04/2017AM	26083
C	01/04/2017PM	25642
D	01/05/2017AM	18996
D	01/05/2017PM	19939
E	01/06/2017AM	22555
E	01/06/2017PM	24746

Output:

Category	01/01/2017AM	11/01/2017PM	11/02/2017AM	11/22/2017PM
A	-7%	-6%	-13%	13%
B	-2%	-1%	4%	-3%
C	5%	-8%	1%	-11%
D	10%	5%	17%	-23%
E	-3%	0%	-2%	7%

I need to calculate the average % based upon the Date value in the straight tablethe average %That means my calculation will be

Example: Let me consider Category "A" value, for that i need the calculation like

Column1: (01/01/2017AM)

(Value_v1 of 01/01/2017PM) - (Value_v1 of 01/01/2017AM) - / (Value_v1 of 01/01/2017AM)

Column2: (01/01/2017PM)

(Value_v1 of 01/01/2017AM) - (Value_v1 of 01/01/2017PM) - / (Value_v1 of 01/01/2017PM)

Regards,

ShakilaD