aggregate & dashboard & month pages
Hi, i have done with several pages: [Aggregate page] - only need input data into column A-C; - column D-P will update automatically with formula; - column D (totals) set with Pentagram icon as well as background&front color to highlight value >= 20; [Dashboard page] - Chart1: TOP20 clients with total points; - Chart2: monthly trend with birthdate slicer under which you can choose different years; [Month pages] - column A-C will update automatically with formula (same with Aggregate page); - only need input data into columns after column E; - cells after columnE have set data list you can pull down and choose value, directly input is also fine, if you input value not in -2~2 it will send alert. feel free to let me know any confusions.