on 2014 Apr 18 7:09 AM
Hello Experts ,
I have created Workbook having 2 queries , each query on different tab ( SFG , FG).
On First tab , I can see Chart , Filters and Information button however on 2nd tab I am unable to see those buttons .
I need those buttons on 2 nd tab also as user wants to use filters (to add free characteristics , restrict by values etc ..)
I have attached screenshots for your reference .
Kindly Suggest .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If I have understood you correctly, you have opened a Query in Analyzer and saved it as Workbook by "Save Workbook". You have opened it and inserted a new worksheet and put "Insert Analysis Grid" and assigned a new DP to it.
Chart, Filter and Information Buttons comes up in Analyzer but cannot come in workbook design in new sheet because we don't have any privilege to add them through standard options in design mode.
An ideal workbook has to be created like below:--
Regards,
Suman
Hi Ganesh,
Can I ask you if you execute the report for the tab with data in the same file that you are using and later on, you execute the other one (tab with no filters) on other file and paste on the file that you are using as workbook?
Have you thought about building it with version 3.5 (friendlier for workbooks)?
It would be needed to execute the first report on one tab, and place in another tab of teh Excel press the Business explorer tool (third icon from the right) and "Insert query", and execute the report that you need.
I hope it helps!
User | Count |
---|---|
68 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.