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 has now been released for TARGIT Cloud.
Planned to be released for TARGIT on-prem in February 2024.
See this article for details: https://community.targit.com/hc/en-us/articles/12033375772956-Pin-calculation-to-top-of-crosstab
BR / 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.