Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to show curve b (of the abc curve) in a kpi?
Hi Mario,
please give a screenshot of your extpected output
Beck
Well, it's a simple thing to sum (value) only the products that belong to curve b .. of the curve abc ... I already have
if (RangeSum(Above(
Sum({$<COD={'1','3','12','13'}>} [VALUE]), 1, RowNo ()), Sum({$<COD={'1','3','12','13'}>} [VALUE]))/Sum({$<CD_FIL={'1','3','12','13'}>} TOTAL [VALUE])< 0.50, 'A',
if (RangeSum(Above(
Sum({$<COD={'1','3','12','13'}>} [VALUE]), 1, RowNo ()), Sum({$<COD={'1','3','12','13'}>} [VALUE]))/Sum({$<COD={'1','3','12','13'}>} TOTAL [VALUE])< 0.80, 'B',
if (RangeSum(Above(
Sum({$<COD={'1','3','12','13'}>} [VALUE]), 1, RowNo ()), Sum({$<COD={'1','3','12','13'}>} [VALUE]))/Sum({$<COD={'1','3','12','13'}>} TOTAL [VALUE])< 0.999999, 'C',
'-')))
But I would like to display in a SIMPLE KPI only the value of CURVE B