I have a scorecard with several rows on KPI values and have different typs like Quantity, Values, Procent etc.
The report I have now is based on IF statement and it works but it take a long time to present the information for the client because
I have a lot of transactions.
Is there any other way to create a scorebord where I have the KPI on the rows and then (current month, ytd, %, pv month, pv ytd, %.
IF(ColumnName = 'Omsättning' ,
if(ColumnName = 'Personel',
if( ColumnName = 'Average',
'% ' & (Amount) / (Hours) * 100,'#,00') ,