09-26-2022 03:06 PM - edited 09-26-2022 03:08 PM
In the below screenshot, I want to add % (beside the numbers) to the utilization % but whenever I try to add % using cube view formatting, it adds % to all of the four columns. Is there any specific way I can just add % to just utilization %.
Note: CM and YTD are two columns. Hours and Utilization are levels which fall under these two columns (CM & YTD)
09-27-2022 04:28 AM
Try this conditional format
If (ColE2HeaderDisplayText = 'Utilization %') Then
ShowPercentSign = True
End If
09-27-2022 05:37 AM
@Fuad95 can you show us where you add the formating? And the columns of your cube view in your designer?
09-27-2022 10:11 AM
This should be in your Cell Formatting.
09-27-2022 08:19 AM
I would suggest breaking the expansion so that you have 4 columns to apply individual column formatting. That's probably the easiest method. You could achieve it with conditional formatting as mentioned previously.