Skip to Content
1
Jan 05, 2023 at 09:22 AM

Show a row of subtotals for Currency Key field

142 Views Last edit Jan 05, 2023 at 06:20 PM 4 rev

Hi,

I have a table widget used in SAC analytics application.

Currency Key column is needed to be placed on the left hand side of Amount in Transaction Currency column, as seen in the screen picture that is given below.

It is desired to show subtotals at the change of each Currency Key value.

Somehow features like Add Row, Add Calculation, Show Totals (on Currency Key dimension from builder panel) does not seem to work as desired in this case.

Appreciate your inputs please!

Note: HANA Live connection is leveraged to create the analytic data model for this application (if that matters).

image.png

Attachments

image.png (50.5 kB)