I have a straight table, in that i have added 20 dimensions and 1 expression.
Out of those 20, i have selected only 7 dimensions as showed dimensions and have hided the rest 13 with the option available in presentation layer (below is the screenshot).
Now, the issue is:
when i click on "Send to Excel" (icon on chart - top right along with minimize,maximize), the excel is showing only the 7 dimensions and 1 expression, which i have made showed columns.
So, how to get the rest of the dimensions also in the excel.. Basically I want to show 7 dimensions & 1 expression in chart and want to see 20 dimensions and 1 expression in excel when they click on 'Send to Excel'