3271466 - Unable to sort on a Calculated measure in Planning import model

Unable to sort on the Calculated measure
Model is an import planning model based on BW

 SAP ANALYTICS CLOUD 2022.21.5 

1. Create a table based on imported BW data model.

2. Take two measures in the Table like Actual and Target

3. Create a Calculation column based on Percentage difference (% YTD Target)

4. When User tries to sort on the Calculation (right-click the TOP row and select Sort Options, the option is grayed out and tooltip message saying:

“Sorting by Total is only available for BW model”  

If User click on any other row, the sorting is available, but if click on Value Sorting   

You get a list of measures to sort by, but the calculation (% YTD Target) is not in the list 

Is this a limitation?

Product defect

Code Correction COD0345191 has been updated with 2025.03

KBA , LOD-ANA-DES , Story Design & Visualizations , Problem