How to calculate Sub-Totals in a crosstab?

Philipp Güntzel shared this idea 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

Files:

I like this idea 0

Replies (3)

Paul Thornton ●

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

Reply URL

Philipp Güntzel ●

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

URL

Paul Thornton ●

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

URL

Paul Thornton ●

Hi Philipp,

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

Thank you,

Paul

Reply URL

Paul Thornton ●

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

Reply URL