Hello,
I'm attaching an example of what I want, because it may be hard to explain. I have 2 dimensions in a chart (a and b). There are only 2 records in the table right now:
dimension a:
A
B
dimension b:
1
null
expression
1
null
The following is just a test, but dimension a and dimension b values are dynamic (the number of values could be 1-x), it isn't fixed like in the example. I want to show all of dimension 'a' to show in a chart, but I only want values of dimension 'b' to show if they aren't null. So in the example, I want to see 'A' and 'B' across the bottom of the chart, but for dimension 2, I only want to see '1', I want to eliminate the null value.
Thank you for any help you can give me!
Josh