I have data of few months.
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
Having three columns - Date, Product and Value
I want to min value out of April, May and June by using Measure.
I want to create Pivot table Row Product, Column Month and last column Min value out of April, May and June.
Date | Name | Value |
01-04-2018 | a | 2 |
03-04-2018 | b | 2 |
05-04-2018 | c | 8 |
07-04-2018 | d | 3 |
09-04-2018 | e | 1 |
11-04-2018 | f | 3 |
13-04-2018 | g | 10 |
15-04-2018 | h | 9 |
17-04-2018 | i | 5 |
19-04-2018 | j | 7 |
21-04-2018 | k | 4 |
23-04-2018 | l | 5 |
25-04-2018 | m | 8 |
27-04-2018 | a | 4 |
29-04-2018 | b | 10 |
01-05-2018 | c | 8 |
03-05-2018 | d | 5 |
05-05-2018 | e | 3 |
07-05-2018 | f | 2 |
09-05-2018 | g | 7 |
11-05-2018 | h | 2 |
13-05-2018 | i | 3 |
15-05-2018 | j | 6 |
17-05-2018 | k | 4 |
19-05-2018 | l | 9 |
21-05-2018 | m | 9 |
23-05-2018 | a | 1 |
25-05-2018 | b | 3 |
27-05-2018 | c | 2 |
29-05-2018 | d | 8 |
31-05-2018 | e | 1 |
02-06-2018 | f | 7 |
04-06-2018 | g | 5 |
06-06-2018 | h | 4 |
08-06-2018 | i | 9 |
10-06-2018 | j | 5 |
12-06-2018 | k | 3 |
14-06-2018 | l | 4 |
16-06-2018 | m | 10 |
18-06-2018 | a | 5 |
20-06-2018 | b | 8 |
22-06-2018 | c | 4 |
24-06-2018 | d | 4 |
26-06-2018 | e | 3 |
28-06-2018 | f | 6 |
30-06-2018 | g | 2 |
02-07-2018 | h | 8 |
04-07-2018 | i | 10 |
06-07-2018 | j | 3 |
08-07-2018 | k | 7 |
10-07-2018 | l | 6 |
12-07-2018 | m | 6 |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
Having three columns - Date, Product and Value
I want to min value out of April, May and June by using Measure.
I want to create Pivot table Row Product, Column Month and last column Min value out of April, May and June.