Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a simple calculated dimension of a date. When filtered the selection pane on top shows the entire formula instead of label. Have tried to make it as a master dimension too, but of no help.
The end user does not need to see this as it looks complicated if its a set analysis expression. Below is the snapshot
One more thing, it might be possible to get the selected count for your field if you input the expression you use for it.
In my case i created a field on the fly with =(Year&'') and I can get a correct value from using this function GetSelectedCount([=(Year&'')]).
So what happens if you do GetSelectedCount([=fiscal year])?