I have a field with Links in it and another field showing number of links in the links field. Both are expressions with some other fields like object name etc, as dimensions. My requirement is to show all these in pivot table and when I tried to show the link field expression as calculated dimension everything went fine except the link is no more a link, instead it's a text. I did so because when there are more than 1 link under one object name, it shows a '-' in that column. In pivot table when the object name is expanded the number of links should be displayed and when it is expanded the links should be displayed. This is the order I require.
Within a pivot you need to display the link as expression then only there is the possibility to set the interpretation to a link. I think your NULL result will be caused through the fact that there more then one value is available - this meant you need to use an aggregation-function like only/min/max/... to return a valid result: Use Aggregation Functions!
Thanks for the quick reply, could you be more specific about how to use those in the expression. I actually have taken the links field from another table and attached it to the current object name and number of links table. When the two tables were separate everything was fine, but now when I merged the two the problem with links exists. I am not able to figure out how to refine the expression and so here I am attaching the one I used to get the links into the current table.
RequestNumber and Link must be definitely unique within the context ob your dimensions Object_Name and Nb_of_Links - if not they will return NULL. To handle this you need an additionally dimension which divided the various values into single values or you need an aggregation-expression for them like:
