Row calculations locked at the top of a crosstab
It's nice to see grand totals in large crosstabs at the top of the table but sometimes these 'normal' grand totals (cube totals) are not what we want so instead we create a row calculation that gives us what we want in this new grand total row.
The row calculation can be dragged above the 'normal' grand total and when the latter is hidden, the new grand total line stays at the top ... until someone sort the crosstab.
It would be nice if a row calculation could be 'assigned' to the top of a crosstab regardless of any sorting. It would be even better if multiple row calculations could be 'assigned' to the top of a crosstab, maybe with some kind of row numbering. A use case for the latter could be that the top calculation shows the sum of all visible and the second calculation shows the sum of all invisible ... and they stay there regardless of sorting.
Comments
Good news!
This feature request is now on R&D's shortlist, and will most likely make it into one of the upcoming releases.
I cannot give you any date yet, but I will keep you updated on progress in this thread.
Best regards / Ole
Example:
unsorted:
sorted:
Yes, that's the problem we need a solution for. The same would happen if you don't sort and exclude JEANS ... unless the calculation is above Total.
This would be extremely helpful to us as well.
Please sign in to leave a comment.