Can we use data from one page as datasource to another page in SAC story or Analytic App?

[former_member786534]

I have created a story/app with multiple pages.

Page 1 has a table based on analytic model some calculated measures and dimensions. I am trying to make a summary report by referring to the lines with totals on Page 2. Is is possible to refer data from one page as source of data in another page....something similar to how we refer data in one excel sheet to another. Is this possible in SAC, any pointers will be helpful.

P.S. the reason for doing this is to meet some very specific report layout requirements which is not satisfied in one table.

[steve_bickerton]

You could simply copy the table/widget to the new tab and format as needed.

[Nverhoeven]

Hi Shilpa,

You cannot reference other tables, what you can do is have a restricted measure calculation at the level of the total you'd like to show with constant selection enabled and use this on the second page.

Check out this blog series for details on restricted measures and constant selection: https://blogs.sap.com/2021/02/02/feature-highlight-restricted-measures-with-constant-selection-in-sa...