Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart dimension that returns just 1 value - by design.
=if(aggr(rank(sum(Cost),4),H_Process) = 2, H_Process)
How can I display the value/output of this expression in the chart title?
Thanks
Thank you for the help. I didn't know where to start.
I found
Concat(
distinct
{<H_Process= {"=aggr(rank(sum(Cost),4),H_Process) = 2"}>}
H_Process
)
did the trick.
Concat(
distinct
{<H_Process= {"=Rank(sum(Cost))=2 "}>}
H_Process
)
Thank you for the help. I didn't know where to start.
I found
Concat(
distinct
{<H_Process= {"=aggr(rank(sum(Cost),4),H_Process) = 2"}>}
H_Process
)
did the trick.