Just wondering if it is possible to filter on a Calculated Dimension within a straight table?
I have tried clicking on the values in the Calculated Dimension column but have noticed that it instead filters on the other, standard, dimensions in order to make it look like you're filtering on the calculated one. However I want to create a bookmark based on selections made in these Calculated Dimensions, so filtering on other columns won't work as these values may change.
Is it possible to do this at all, or do they just not work in that way?
and it still seems to be bringing back the right values. Will need to do some more testing, but looks like this lets me select the owner name rather than the associated account number.
But yeah the bit about the bookmark. Say that I wanted to save a bookmark of accounts that I am the latest owner on. With the way the dimension was before i'm actually selecting the account number rather than my name. At the time of creation this wouldn't be a problem but that account could then be owned by someone else. However because my bookmark saves the filtering of the account number rather than my name in the owner field, as soon as there's a change the bookmark is incorrect.