Test Type ID: 1,2,3,4
Test Type Description: Fit, Fabric, Red, Green
Approve Date
I need to create separate dimensions for the Test Type Description as I would like to use them individually.
1. Fit Test = If([Test Type ID]=1, [Approve Date])
2. Fabric Test = If([Test Type ID]=2, [Approve Date])
3. Red Test = If([Test Type ID]=3, [Approve Date])
4. Green Test = If([Test Type ID]=4, [Approve Date])
These dimensions work fine on their own as i can untick not to display the nulls byt when I use them all together, I have to uncheck the "don't display the nulls" as the rest of the fields won't display and also it creates extra lines.
How else can I write these expressions so that I can use them together in a table without it creating extra null lines?
