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?