I think this is a simple problem, but it probably isn’t.
I have a metric (Metric - Is locked) of type: Dimension (Locked) with only Yes or No as options.
| Dimension: Version | Metric: Yes/No |
|---|---|
| Actuals | Yes |
| Plan | Yes |
| Forecast | No |
Can I easily flip this around to show the inverse of the metric (here using firstnonblank)?
| Dimension: Locked | Metric: Version |
|---|---|
| Yes | Actuals |
| No | Forecast |
Hi
You can, please see below a screenshot. You were right on the syntax!
Hope this helps, please note you will lose the “lock status” for the “Plan” version as it does get ignored because of the FIRSTNONBLANK aggegrator. Not sure what your end goals is here so might not be an issue.
Thank you! This does exactly what I was looking for. Too bad my end goal involves a much more complex structure. But this did indeed block my thinking 👍
Great to hear. If you need any more support with that end-goal feel free to reach out!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.