Analytics Software

Hi,

I have a requriment that I have show Grand Total of a table as first Row in a table.

Now to achieve that I have I had to do a UNION and i am able to achive grand total as row in report and using sorting i am able to display it at the top but but problem is one view client want only Grand Total Row and in other view all the rows.

So, is it possible to HIDE or EXCLUDE rows in different views for example in Table view 1 i only include rows without Grand total row so i want to hide one row in this view and in table view 2 I include grand total row at the top and rest of detais at the bottom

P.S: I have to do in in same repot as both views must be exported in one excel and I need to do UNION from Grand total because of OBIEE formatting bug that system generated Grand Total formatting does not get exported in Excel and that makes report looks bad.

Thanks