Discussion Board for collaboration related to QlikView App Development.
I have a pivot table with 3 dimensions (Year, Quarter, Month) and calculating cumulative sum of sales using below expression
RangeSum( Above(TOTAL Sum(Sales), 1, Rowno(TOTAL)))
Cumulative sum is working fine when dimensions are fully expanded and not giving correct result when its collapsed.
Do we have any workaround for this issue?
@BabyyGurusamy can you show where it is showing with expand and collapse?
Please refer the attached screenshot.