SAC Linked Analysis on a Calculated Measure

[GavinMonteiro3]

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.

[N1kh1l]

gavin2160

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

Calculated Dimension

Define Ranges based on your bucket

Br.

Nikhil

[Sowmiya_Chinnappan]

Hi gavin2160,

Did you tried with filtering the Data Points,

[GavinMonteiro3]

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.