As per requirement, In single sheet based on condition, I performed drilling on first chart (straight table) then it will shows next chart(straight table).same way I performed drilling from on 2nd chart then it will shows third one table box.the table box is last level only.in this last level, how do I make it static report(read only).there is no read only option in table box like straight table and even i selected read only option in sheet level then I couldn't performed drilling on first chat and second chart.I don't want filtered the data from table box chart.Just I want static report in the last level table box report.please suggest me solution on this.
Generally Straight table have read only but not Table Box. So while user go to Level 3 activate the Table box in the new sheet and add the Read only on sheet Level.
Sheet Properties --> Security --> Select Read only
Not sure why you want to use Table box at the last level. You can also use a straight table with =1 as expression and then in presentation tab hide the expression column.
Also for drill down may be you can consider creating drill down group dimension that might help in your case.
Share some sample file so that specific prob can be addressed
Yes, i tried it worked. i could reason out one thing, that if i do not mention any aggregation function, QV will internally use ONLY() function and since it will return NULL, we will get the record set.
