Home » Developer & Programmer » Reports & Discoverer » Discoverer Crosstab figures appear incorrect
Discoverer Crosstab figures appear incorrect [message #238426] Fri, 18 May 2007 00:12 Go to next message
Messages: 33
Registered: November 2005
Location: Australia
Hi all

I have a crosstab, with a hierarchy (National > Division > Category > subcategory > item) on the left, and sum(sales) as the datapoint. I have parameters on all items, and in my test case I am filtering by a value right down to subcategory level.

When I start drilling down from National I have a figure of 1024. Each level I drill down = 1024. However, when I finally get down to the lowest level, ITEM, and export that data to excel and sum the sales for each item, I get a different figure, 767, which I believe is the correct figure.

Can anybody suggest any settings which may be effecting this? It has me a little stumped...


Re: Discoverer Crosstab figures appear incorrect [message #238461 is a reply to message #238426] Fri, 18 May 2007 03:17 Go to previous message
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Sounds strange... Could you provide us with a sample data set? Like: this is the base table(s) content, this is the output in the crosstab table, this is the result after filtering, etc.
Previous Topic: printing problem
Next Topic: Help with % Total
Goto Forum:

Current Time: Sun Oct 23 11:10:48 CDT 2016

Total time taken to generate the page: 0.07752 seconds