hi , source data: LOAD * Inline [ Year,Loc,Sales,Target 2015,a,100,200 2015,b,250,150 2015,c,50,100 2016,a,250,200 2016,b,200,20 2016,c,350,200 2016,d,10,5 2017,a,300,200 2017,b,100,300 2017,c,400,200 ] ; need output like below in bar chart: Year Loc Sales Target 2017 c 400 200 2017 a 300 200 2016 c 350 200 2016 a 250 200 2015 b 250 150 Requirement: top 5 records based on sum(Sales) and year descending order. dimensions: Year,Loc Expression : for Sales =Sum({} Target) in table output coming properly but when i create bar chart output not in required format.
