Pivot table formatting issue (2 formatting types- Only 1 type will show)
Hello
I have been building an aggregated level of data in my script to be displayed in a pivot table. Data values will be a mixture of % and hh:mm in 1 nested if statement
I have noticed that when writing all formatting in the script, the pivot table will only accept 1 of those formats in the 1 nested if expression. If I want all data items to show then formatting does not work for any data values.
Do you know if it is possible to do all formatting in the script for 2 different types of formats (% and hh:mm) and for it to show accurately in the pivot table for 1 nested if statements?
