How to show total at the end of SAC tables created by linking two BW Live Models

[zee_siddique15]

Hi All,

I have created a SAC table , sourced from 2 live models linked via the common dimensions between them.

Table Columns :- Have measures (yellow coming from 1st Live model )

                                            (Orange coming from 2nd Live model)

                                            (Blue are the calculated measures within the story)

There are 3 dimensions listed here , we want to see Total in the end by Planting (i.e. the first dimension)

When we hover the mouse on the Planting dimension header, the total option is greyed out (this behaviour is true for the other 2 dimension listed in the table below).

Is there a way we can show Total in the bottom?

Regards,

Zeenat S

[vishalakshmi]

Refer: 

https://community.sap.com/t5/technology-q-a/sap-analytics-cloud-sum-table-columns/qaq-p/12626580

[zee_siddique15]

Hi @vishalakshmi, Thanks but I am reading the data in my SAC table by blending two live model where (Arrange total on the Table builder panel doesn't work