Hi All,
I have a source dataset like as,
Source:
Category | Date | Value_v1 |
A | 01/01/2017AM | |
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