Trying to add percentage and gauge in the same cell
My question is how do i create a gauge and the percentage number in the same cell. The gauge will work according to the percentage, for example if the number is above 50% the gauge will turn green, and if the number is lover that 50% then the gauge will turn red. Please note i would like the gauge and percentage in the "SAME CELL" like the example in the table above. I am using a pivot table for this report.