HOWTO: Hide values for a measure based on something else -
08-22-2005
, 02:48 PM
Hello everyone,
I don't have much experience using Analysis Services (2KSP4) and I would
like to hide the value of a measure (zero it in fact) when the the user is
looking at the 5th & up period. Let me show an example:
Period MyMeasure OtherMeasure
2005-08-08 500 500
2005-08-15 600 500
2005-08-22 800 600
2005-08-29 500 700
2005-09-05 0 800
2005-09-12 0 900
2005-09-19 0 850
.....
How can I obtain such thing considering that MyMeaure is a calculation based
on 3 other measures? Any help would be greatly appreciated. Thanks. |