Allow Subtotal Columns in Crosstabs

[bhavin_shah9]

Hello folks

I am trying to create a column total within a crosstab using Lumira 1.27. I looked into the below SAPIdeas link but this is not what I want.

https://ideas.sap.com/SAPLumira/D26482

Instead I want the sum of the row in a different column. In the attached example I would like to see my total revenue for a product family across divisions.

Is there a way to achieve this?

Thanks for your help.

Bhavin

[TammyPowlas · Accepted solution]

What was your output of the above?  See mine below:

[bhavin_shah9 · Accepted solution]

Thanks Tammy. This is the type of output I got as well. I would like just 1 column ( saying Total ) that has the sum of values for 2014 and 2015 in your example for each row. So for Analytics it should say 24 and so on. Is that possible?

Bhavin

[TammyPowlas · Accepted solution]

I don't see how to do that; perhaps that is another idea for Idea Place.