This content has been marked as final. Show 3 replies
bcz column selector or view selector or _ any prompt_ contains multiple values like dropdown list. so when ever u export report into exel or any fromat
it will display data according to u r current selection but not dropdown list.
ex:- u have a column selector for 'year' and 'month'.
when ever u selected year in column selector u r report shows data with year column. you can able to export year data only.
but exported report will not show data in month column and dropdown lists have in report.
and you can not export a drop down list from bi to any fromat,