I am using the pivot table;
how can I make the text in the last column appear in the left side instead of the right side.
I have to scroll all the way to the right to be able to see the text in the PHI or Non-PHI column.
How is your pivot table generally configured? Is the PHI field an aggregation (that is translated into a static string value) or a row grouping? I am a bit confused since it is right-aligned - which normally is default for aggregations. However you are displaying a string text - which is not so easily possible with the pivot table aggregations.
In case it is a translated aggregation - the alignment of aggregations within a pivot table is hidden in the conditional formatting. You could configure “always true” and add the preferred alignment.
On row groupings I am afraid you can not set the alignment - however, this should already be left-aligned by default. Since you only have two values you could also reduce the column width to reduce the white space.