Search results for query: *

Hi again, In the same report, there is something I am trying to do: I have a crosstab having the following structure (data on the right, just giving the row structure): Supplier A Group1 Jan 11 Feb 11 ... Level 1 P1 200 400 P2...

Hi, I have a report with a crosstab having the following structure (data on the right, just giving the row structure): Supplier A Group1 Jan 11 Feb 11 ... Level 1 P1 200 400 P2 300 500 ... Level 2 P1...

Thanks, that worked

Thanks a lot! That worked fine, I had tried that but didnt know about the "Relative position" - which eventually solved my problem. Thanks again!

Hi I have the following Cross tab output: Total 2011 01/11 02/11 .. 12/11 Total 2012 01/12 02/12.. Prod 1 Prod 2 Prod 3 The 01/11, 02/11 represent MM/YYYY which are grouped by @Year and I am generating a cross tab summary of Annual Sum. The issue is the annual total (cross tab...

Hi, Thanks for that reply, Tweaking with SQL output and with your reply, I managed to achieve what I wanted. On a different note, but with the same report - I am struggling with the following: Cross tab output: Total 2011 01/11 02/11 .. 12/11 Total 2012 01/12 02/12.. Prod 1 Prod...

I tried but cant attach an image to this post. I hav uploaded it here: https://picasaweb.google.com/lh/photo/QjbOI3wxZ20FCT6h1HPxzA?feat=directlink I have to show the annual average when New Users and annual sum when Sales, in the same column - ANNUAL (highlighted), which is a crosstab...

Right, I'll try to explain in as much detail as possible: The data coming in the report is through an oracle package having a stored proc, and the output format is as follows: Record Value Month x 120 Jan 11 x 130 Feb 11 x 180 Dec 11 Where x is in the...

Hi, I am trying to fetch the fieldname which identifies the crosstab's grandtotal and subtotal fields which I can use in other formula fields, and also use to show a graph. Since they are not database output fields, but are crosstab autogenerated ones, I cant get hold of the fieldname. Please...