Forum Discussion
Solved
Data extraction from Pivot
Dear Experts, Greetings! I have a data like below(Worksheet attached too):- Column A(having rntis), B (having slots) and C having the transmission(DL_1_x) Out of this , fo...
This is what I got from the Excel formula
= PIVOTBY(Rnti, DCI_Slot, SIGN(ISTEXT(DCI_Info)), PERCENTOF,,0,,0,,,1)with a bit of conditional formatting
i thought you may identify the threshold for low transmission (e.g., using AVERAGE(), MEDIAN(), or PERCENTILE()), then apply conditional formatting or formulas to mark “x” in slots that fall below the threshold and compute percentage loss relative to the highest transmission for each RNTI.