I want to make a Bar chart For total amount in for last 3months. For example if user selects Report_Month= 1214 then i should show 3bars for 1214,1114,1014. I created 2 other fields like Prev_Report_Month1 & Prev_Report_Month2 in script - which calculates the Previous MonthYear values.
In chart i Used below expressions. dimension : Report_Month (1214,1114,1014,0914 etc..) Expression1:Sum(AMOUNT) Expression2: sum({<Report_Month={"$(=num(Only(Prev_Report_Month1),'0'))"}>}AMOUNT) Expression3: sum({<Report_Month={"$(=num(Only(Prev_Report_Month2),'0'))"}>}AMOUNT)
