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
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.
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 ?