Thank you for your reply
Here is my sample data in excel
1. Year_Month(Drill down)
2. Emp Name
Load *, Year(DELIVER_DATE) as yr,Month(DELIVER_DATE) as mnt;
SQL select * from Sample Excel
LOAD Distinct yr
Left Join (TempTable)
LOAD Distinct EMP_NAME
DROP Table TempTable;
I have already calculated cumulative line chart by empname and Year (Please check attached snapshot in question).
What I need is , I want by empname, year , month, . If I select any year, it should show by month of that selected year.
Sample.xlsx 189.8 K
Please check this sample qvf file.
Please modify in this.
Year sorting is not working in this
Sample.qvf 288.0 K
If(GetSelectedCount(yr) <> 1,
Aggr(RangeSum(Above(Sum(AMOUNT), 0, RowNo())), [Emp Name], (yr, (NUMERIC))),
Aggr(RangeSum(Above(Sum(AMOUNT), 0, RowNo())), [Emp Name], (mnt, (NUMERIC))))
Sample (1).qvf 288.0 K