Rows: A(data1,data2,data3),B(data4,data5),C(data6,data7)
Columns: D
Values: E
Here I would like to add different target for “E”
As while I adjust the conditional formatting for “E”, I can only add same one for all data under “E”, but I would like to add different conditional formatting for “E” :
for example
while the RowA = data1, Row B=data4 and row C =data7, the conditional formatting for “E” should be" less than 20, red, greater than 20, green"
while the RowA = data1, Row B=data5 and row C =data6, the conditional formatting for “E” should be" less than100, red, greater than 100, green"
How to add different targets for pivot table to make sure above changes?
Please kindly let me know if the question need more clarity.
For your scenario, there are few more steps required to achieve the conditional formatting for each row based on a single target value.
1/The target value is repeated for each row by using the level aware calculation (calculated field = target_by_warehouse_id_date ) .
2/A target check logic is then introduced ( calculated field = target_check )
3/Conditional formatting is then applied on the value based on the target_check