cancel
Showing results for 
Search instead for 
Did you mean: 

SAC Linked Analysis on a Calculated Measure

GavinMonteiro3
Participant
0 Kudos
414

Hi,

In SAC Dashboard, we have Store wise Revenue & Expenses Store wise, based on which we have a calculated measure "Net Profit " & "Net Profit%"

The requirement is to have linked Analysis in which Stores >5%, 5-10%, <0% Net profit can be selected by the user.

Based on which the filtering of stores should take place.

How can we achieve this in SAP Analytics Cloud (SAC) Dashboard?

Regards,

Gavin.

Accepted Solutions (0)

Answers (2)

Answers (2)

N1kh1l
Active Contributor

gavin2160

Create a measure based dimension. You can use ranges to categories the values.

Calculated Dimension

Define Ranges based on your bucket

Br.

Nikhil

0 Kudos

Hi gavin2160,

Did you tried with filtering the Data Points,

GavinMonteiro3
Participant
0 Kudos

Hi Sowmiya,

Net Profit % could be 1,2,3,4,5,6,7,8% & so on.

Hence, first the net profit needs to be grouped in the buckets like 0 to 5% will go in 1 bucket & so on.

Based on this buckets, linked analysis should be visible.