Changing labels dynamically

[Steve]

 have a report written in Report Studio. It's like this:

Products                   Revenue              Cost           Margin        Accounts
-----------                   -----------          ----------          ---------      ------------

Notebook Computer   12,000           10,000            2,000            120

The dimension Products has 5 drill down levels.  For the 1st two levels, the last column 'Accounts' should say 'Accounts' and for the last 3 , it should say 'Subscribers' . How can we do this? By making a Report Expression?

If yes, what kind of expression will it be? I can't seem to figure out how to determine which drill down level is the user currently on?

Thanks,
Steve

[Moody]

From a summary level, you'll need to create a report expression to first figure out how you can identify the labels that need to change. Then you'll need to use Conditional Formatting (concentrate on Conditional Text) to use that Report Expression to change your labels.

[Steve]

That's what I thought too... I understand condition explorer.

What I want os what expression can I create to identofy which level of drill-down the user is at.
What would be the expression that would determine the current level of drill-down ?