on 03-18-2024 8:02 AM
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,
By using this measures I made this table structure
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
I 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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.