Add a Total column on the right in a crosstab

[former_member597137]

Hi everyone,

I want to add a total column to a crosstab on the right of the table but I'm not getting the expected result.

It probably has to do with the breaks but I tried several thing and it still doesn't work.

Before:

After:

What I want:

Thank you for your help!!

PS: I'm using webi 4.1

Marco

[Tom_N8 · Accepted solution]

Hi Marco,

Once you have created your cross table you simply highlight a column in your body, go to the Analysis tab, select "Functions" > Sum and choose to insert a sum for columns and rows. This will automatically add a totals column to the end and a totals row to the bottom of your cross table. You can manipulate the formula in the totals rows and columns as you see fit.

Regards,

Tom

[former_member597137]

Hi Tom,

Thank you! It worked perfectly!

And sorry for the late reply.

Marco

[Tom_N8]

Hi Marco,

Great to hear this worked for you 🙂

Kind regards,

Tom