cancel
Showing results for 
Search instead for 
Did you mean: 

Calculate Measured based dimeson in SAC Analytical Application

darshansavani
Explorer
0 Kudos

Hi Everyone
I am trying to build one measure based dimension where that measure is calculated at model level with date function "Previous"
here this all are Model level measures,
darshansavani_0-1710747699386.png
By using this measures I made this table structuredarshansavani_1-1710747995302.png

Where I wanted to remove the entire row, if Inv ratio % of last month is < 1%.
Also keep in mind that we have left side material hierarchy !!

I tried to make a flag using Measure based dimension and than filter to remove row, but won't work

darshansavani_2-1710748237109.pngI added context as well but didn't work

Please let me know if you find any missing steps or logic to achieve.
I would really appreciate your answer 
Thanks in Advance 

Accepted Solutions (0)

Answers (1)

Answers (1)

N1kh1l
Active Contributor
0 Kudos

@darshansavani 

Another way could be to make the relevant row 0  ( multiply by 0) when Inverse % less than 1 %. Zero suppression will remove the row .

 

Nikhil