Skip to Content
0
Former Member
May 09, 2008 at 06:26 AM

Issue in Result row display for free char drilled for query with structures

17 Views

Hello All,

I have a structure in the Row with various calculated subtotals for e.g:

Total Interco sales(selection on some G/L accounts)

Total ext sales(selection on cost center+group accounts)

Total Revenue (formula in structure) = Total interco sales + Total ext sales

In the column I have the key figure called balance.The net effect of this is in the report out we have :

subtotal**********balance

Total interco sales*100

Total ext sales*****200

Total revenue*******300

This is fine in the initial layout ,but when there is further drill down say on the G/l account then the account numbers are repeated for total revenue as well .For e.g

*********************G/L account Balance

Total interco sales 11100********50

*********************12000********50

*********************result --->*****100

Total interco sales**11100********50

***********************12000********50

***********************Unassi******100

***********result---->**************200

Total revenue******11100********100

***********************12000********100

************************#*************100

*Overall result -->***************** 300

However the users dont want to see the g/l account break up for the total revenue in this case.i.e if g/l account is drilled down then only the break up should be seen for total interco sales & ext sales and not for revenue.i tried using supress individual result in case of total revenue but it was not helpful.Also building something like hierarchy with text nodes isnt feasible since there are a lot of subtotals with different char restrictions.Any ideas on how to achieve this?