How to calculate Sub-Totals in a crosstab?

Philipp Güntzel shared this idea 18 months ago
Idea Logged

Hello altogether,


currently I am facing a problem concerning the sub-totals of a crosstab.


How is it possbile to display (see attached picture) the row totals after each quarter? So totals for region after each quarter?


I already tried it with subqueries but it doesn't seem to work.


Thanks

Philipp

Comments (3)

photo
1

Hi Philipp,

Unfortunately there are a few limitations with Crosstabs and sub totals is one of them. There is an enhancement in our system to have this added, but there has been no movement on this as yet, so I cannot provide an ETA as to when or if this will be added in the future.

Sorry for the inconvenience this might cause.

Regards,

Paul

photo
1

So you don't see any way to do a workaround?

photo
1

Hi Phillip,

At this stage with Crosstabs there is no current work around, but there is an enhancement to have this added in the future. I can keep you updated if there is any movement on this.

Regards,

Paul

photo
photo
1

Hi Philipp,

Just touching base to see how you are going and if you need any further help with this?

Thank you,

Paul

photo
1

HI Phillipp,

I have not heard back from you for some time, so I am going to move this question into an Idea as mentioned previously, however if you need further help, please get back in touch.

Regards,

Paul