Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

drill down consolidations results in the same report window?

Status
Not open for further replies.

renu123

Programmer
Jun 11, 2001
43
IN
Hi!
Is it possible to drill down on elements in a consolidation , and have the drilled down values displayed in the same report window.
In case of attributes, using 'outline mode' helps(with the restriction that more than one attribute should be marked as row elements).
But, in my case, I have a consolidation, CONS whose elements look something like this:
A, B, B-A, (B-A)*100/B
My report has CONS as row element and 'time' as column element.
In this case, I want to drill down on A or B, and want the drilled down data to be displayed in the same report window and not in a new report window.
Also, in the same report window, the row arithmetic should hold good for the third and fourth consolidation elements.
 
In the case of con element (B-A)*100/B, what do you want the drill down elements to show?
Nick
 
Only, A & B should show drilled down detail data. Since, the third and fourth element (here, it is (B-A)*100/B) are results of row arithmetic, they should be the same. There is no further detail to be viewed there.
That is, as I mentioned in my previous post,
In the same report window, the row arithmetic should hold good for the third and fourth consolidation elements.
A-----|
|A1--|
|A2
B-----|
|B1--|
|B2
B-A
B-A*100/B (these resluts in the same as it is the same formula applied for detailed data)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top