Hi,
While generating the report with sorting of multiple columns which are not used in the report.
Bcoz, when I sort the report with the multiple columns and by the time when I remove the sorted columns which are not required in the report, required sorting fails.
Kindly do provide me some solution with the above.
Regards,
Rajat
rajat_1802 (BOB member since 2008-09-23)
What? Do you want to sort the block/table by columns which are not present in that block? I don’t think you can achieve this in Web-I. It may be possible in Desk-I by hiding the columns after the sorting is done. But in Web-I, you can’t do it, unless you minimize the width of the column very small and then playing with the borders and font colors to appear white or whatever to make it not visible in the document. But remember, when you do this and get it in Excel, the columns on which you played will appear if you click the cell.
Jansi 
(BOB member since 2008-05-12)
Hi,
It is possible in Web-I, If i understood your requirement correctly.
Did you have fiscal quarter or year dimension in your table and measure variable? if YES , then first place it as left most column and right to it add columns on which you need filters and apply and then remove those filtered one’s from report. Now you can see the table as per your requirement.
Thanks
BOCP (BOB member since 2007-07-02)