Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I would like to desplay the automatice table totals function In a kpi
in this pic im calculated the column i would like to sumtotal and present in kpi
if (count({<[Error_Ind]={'1'},[Env]={'AGIRA'}>} Error_Ind )>10000,max({<[Error_Ind]={'1'},[Env]={'AGIRA'}>} failedkeys ),count({<[Error_Ind]={'1'},[Env]={'AGIRA'}>} Error_Ind ))
How shuld i writh it in the kpi
Is it possible to simply display the automatic totals function shown in the table?
Thanks
what is the error you are getting if you are using same expression in KPI?
try some of the below options might help you
1: Sum(yourexpression)
2: Sum(Aggr(Sum(yourExpression),your_all_dimension_which_present_in_table))
Regards,
Prashant