Is it possible to have partial sums on the second pivoted dimension?
My pivot table has this structure:
I need to split the grand total column into Total and Mava.
My workaround is to create a separate table without the Year dimension where the years are summed up for Total and Mava. But since there is no way to synchronize the scrolling between charts in Qlikview, the separate table becomes an almost useless solution.
Is this possible to customize the total column?