Summing Column Outputs From Crosstab

[pliskers_dup_528]

I am performing a basic crosstab that results in three columns of summed data, and I’d like to add a fourth column containing each row’s total of the three columns. I read a posting in which someone suggested doing a Grouping and summing the data prior to the Crosstab, but I’m unclear how to structure and append those totals in advance of the Crosstab.

Any suggestions, please?

[Gaurav_dup_112]

Hi @pliskers_dup_528,
can you please provide the dummy data for more clearification?

[BenMoss · Accepted solution]

Within the cross-tab itself you can perform multiple aggregations, it sounds like at the moment you are just using SUM.

There are also Total options within there. It sounds like you want 'TotalRow'. Select this option and it will add this additional column for you.

Ben

[LordNeilLord]

Hey @pliskers_dup_528

Do you mean something like this?

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[pliskers_dup_528]

That's all I needed - I'm a newbie and hadn't explored all of the checkboxes.  Thank you!