cancel
Showing results for 
Search instead for 
Did you mean: 

How to limit column in an SAC story with rank values to top 50

MadhuLodugu
Explorer
0 Kudos
73

I would like to know how a story with a table in SAP Analytic cloud can be filtered to display only records pertaining to top 50 values of a rank column in the story. I added the rank column on a existing measure using the 'Client Calculation' option available. Now I cannot access this new rank column like other measures as it is a runtime calculation. Can anyone let me know if this is feasible, if so, please let me know how.

 

 

Regards,

Accepted Solutions (0)

Answers (1)

Answers (1)

MadhuLodugu
Explorer
0 Kudos

I found that it can be done by using the Top N option available. This can be used by right clicking on a cell of the measure column and choosing the 'Top N' option. I thought that the top n was available only to charts.

 

 

Regards,