I'm not sure what the best way to do this is. I'm creating a pivot table which displays information on certain orders. For one of the dimensions I'm displaying, I only want the first value that comes up. I've used firstsortedvalue before, but in this case I don't actually want to sort them by anything, I just want the first record that is stored for that field. I tried using the First() function but I got the "//error in calculation" message displayed in the table.
I also tried creating an entirely new field on the data import using the firstvalue command but that also seemed to cause a problem. Any ideas?
If I have a dimension, say it is called "MyDimension", that has 3 values - A, B, C. If I want to show a chart that has only results from Value = A, I can do that by putting a set in my expression:
sum( { < MyDimension = {A} > } Sales )
Now the chart will not display B or C because one of the default options in the presentation tab is to suppress zero results.
ah I see. Interesting functionality but not something that I can use. This field contains a set of entries for each order which aren't necessarily the same for each order. Creating a set would possibly eliminate correct values for other orders.
