I have developed a sales dashboard, here I want an another metric to show the sum of sales on the first day of current selection. Like, if current selection is “Product AAA” then it must show the sum of sales for “Product AAA” on the first day of sale based on Pol_Date.
Below is the example table structure and I know it can be performed using Set Analysis but not sure how to access minimum date in set analysis and generate this expression.
Pol_ID Pol_date Product Sales P001 05/12/2014 AAA 4567 P002 04/03/2014 BBB 6789 P003 04/03/2014 AAA 3243 P004 05/03/2014 BBB 8967 P005 06/01/2014 CCC 7865 P006 06/01/2014 BBB 3456
Please help me to perform this.