Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to create some KPI, at the level of the line, but first I'm testing at column. I've created an expression like :
=sum( {$ <MonthID = {$(=Max(MonthID))},
Date = {"<=$(=Max(Date))"},
Year = ,
Quarter = ,
Period = ,
= ,
Month = >*<numerolinhatot={"L005"}>}Amount
But I wanted the value of the line "L005" to replicate in all rows, but is only appearing for the line itself.
The ultimate goal is to create KPIs, the like (L005 + L006) / L007
Thanks in Advance
Bruno