I have data of few months.
[TABLE="width: 201"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Name[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD="align: right"]01-04-2018[/TD]
[TD]a[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]03-04-2018[/TD]
[TD]b[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]05-04-2018[/TD]
[TD]c[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]07-04-2018[/TD]
[TD]d[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]09-04-2018[/TD]
[TD]e[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]11-04-2018[/TD]
[TD]f[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]13-04-2018[/TD]
[TD]g[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]15-04-2018[/TD]
[TD]h[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]17-04-2018[/TD]
[TD]i[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]19-04-2018[/TD]
[TD]j[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]21-04-2018[/TD]
[TD]k[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]23-04-2018[/TD]
[TD]l[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]25-04-2018[/TD]
[TD]m[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]27-04-2018[/TD]
[TD]a[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]29-04-2018[/TD]
[TD]b[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]01-05-2018[/TD]
[TD]c[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]03-05-2018[/TD]
[TD]d[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]05-05-2018[/TD]
[TD]e[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]07-05-2018[/TD]
[TD]f[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]09-05-2018[/TD]
[TD]g[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]11-05-2018[/TD]
[TD]h[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]13-05-2018[/TD]
[TD]i[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]15-05-2018[/TD]
[TD]j[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: right"]17-05-2018[/TD]
[TD]k[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]19-05-2018[/TD]
[TD]l[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]21-05-2018[/TD]
[TD]m[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]23-05-2018[/TD]
[TD]a[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]25-05-2018[/TD]
[TD]b[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]27-05-2018[/TD]
[TD]c[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]29-05-2018[/TD]
[TD]d[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]31-05-2018[/TD]
[TD]e[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]02-06-2018[/TD]
[TD]f[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]04-06-2018[/TD]
[TD]g[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]06-06-2018[/TD]
[TD]h[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]08-06-2018[/TD]
[TD]i[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]10-06-2018[/TD]
[TD]j[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]12-06-2018[/TD]
[TD]k[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]14-06-2018[/TD]
[TD]l[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]16-06-2018[/TD]
[TD]m[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]18-06-2018[/TD]
[TD]a[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]20-06-2018[/TD]
[TD]b[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]22-06-2018[/TD]
[TD]c[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]24-06-2018[/TD]
[TD]d[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]26-06-2018[/TD]
[TD]e[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]28-06-2018[/TD]
[TD]f[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: right"]30-06-2018[/TD]
[TD]g[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]02-07-2018[/TD]
[TD]h[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]04-07-2018[/TD]
[TD]i[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]06-07-2018[/TD]
[TD]j[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]08-07-2018[/TD]
[TD]k[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]10-07-2018[/TD]
[TD]l[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: right"]12-07-2018[/TD]
[TD]m[/TD]
[TD="align: right"]6[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 201"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Name[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD="align: right"]01-04-2018[/TD]
[TD]a[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]03-04-2018[/TD]
[TD]b[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]05-04-2018[/TD]
[TD]c[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]07-04-2018[/TD]
[TD]d[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]09-04-2018[/TD]
[TD]e[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]11-04-2018[/TD]
[TD]f[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]13-04-2018[/TD]
[TD]g[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]15-04-2018[/TD]
[TD]h[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]17-04-2018[/TD]
[TD]i[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]19-04-2018[/TD]
[TD]j[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]21-04-2018[/TD]
[TD]k[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]23-04-2018[/TD]
[TD]l[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]25-04-2018[/TD]
[TD]m[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]27-04-2018[/TD]
[TD]a[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]29-04-2018[/TD]
[TD]b[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]01-05-2018[/TD]
[TD]c[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]03-05-2018[/TD]
[TD]d[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]05-05-2018[/TD]
[TD]e[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]07-05-2018[/TD]
[TD]f[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]09-05-2018[/TD]
[TD]g[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]11-05-2018[/TD]
[TD]h[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]13-05-2018[/TD]
[TD]i[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]15-05-2018[/TD]
[TD]j[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: right"]17-05-2018[/TD]
[TD]k[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]19-05-2018[/TD]
[TD]l[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]21-05-2018[/TD]
[TD]m[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]23-05-2018[/TD]
[TD]a[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]25-05-2018[/TD]
[TD]b[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]27-05-2018[/TD]
[TD]c[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]29-05-2018[/TD]
[TD]d[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]31-05-2018[/TD]
[TD]e[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]02-06-2018[/TD]
[TD]f[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]04-06-2018[/TD]
[TD]g[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]06-06-2018[/TD]
[TD]h[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]08-06-2018[/TD]
[TD]i[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]10-06-2018[/TD]
[TD]j[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]12-06-2018[/TD]
[TD]k[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]14-06-2018[/TD]
[TD]l[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]16-06-2018[/TD]
[TD]m[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]18-06-2018[/TD]
[TD]a[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]20-06-2018[/TD]
[TD]b[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]22-06-2018[/TD]
[TD]c[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]24-06-2018[/TD]
[TD]d[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]26-06-2018[/TD]
[TD]e[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]28-06-2018[/TD]
[TD]f[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: right"]30-06-2018[/TD]
[TD]g[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]02-07-2018[/TD]
[TD]h[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]04-07-2018[/TD]
[TD]i[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]06-07-2018[/TD]
[TD]j[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]08-07-2018[/TD]
[TD]k[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]10-07-2018[/TD]
[TD]l[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: right"]12-07-2018[/TD]
[TD]m[/TD]
[TD="align: right"]6[/TD]
[/TR]
</tbody>[/TABLE]
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.