Discussion board where members can get started with Qlik Sense.
I am facing sorting issue in pivot table.
1. I have write formula like sum (sales) but it is appiled only first dimension.
2 . For second dimesion I also used aggr function as well.
note:- For first field sort order is working but in further drill its not.
Please help me if nay one who knows rather than this.
Did you tried this?
Pivot Table Sorting - Qlik sense
It Helps me but too much calculations
So your first dimension is salesmen.
Your second dimension will be "=AGGR(DUAL([Customer],RowNo(TOTAL)),Salesmen,[Customer])"
The third dimension will look like "=AGGR(DUAL([Number],RowNo(TOTAL)),Salesmen,Customer,[Number])"
It Helps Me
Nice is your issue resolved ? please close the thread
It takes time for calculation or else for small data set its good .
I am looking for any other alternative.
marcowedel might help ?
please post a sample application containing some data as well as your current pivot table and specify your required result.