question

vishalchitrala-8227 avatar image
0 Votes"
vishalchitrala-8227 asked HerbertSeidenberg-6295 answered

Conditinal formating in pivot table


[1]: /answers/storage/attachments/114608-capture.png


Hi ,
I need to create a new column in excel based on 'Row Lables' - When 'Count of Report Nam' <=2 then "Other" Else the value in Row Label.

Ex: ERPS should be in "Others" bucket and OCB should be OCB as it is <=2

office-excel-itprooffice-scripts-excel-dev
capture.png (9.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emizhang-msft avatar image
0 Votes"
emizhang-msft answered

Hi @vishalchitrala-8227,
Is it possible to create an auxiliary column in source table?
I created a sample, I entered the formula as an auxiliary column and created a new PivotTable:

 =IF(COUNTIF($A$2:$A$44,A2)<=2,"Other","")

114850-416.png

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.





416.png (45.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HerbertSeidenberg-6295 avatar image
0 Votes"
HerbertSeidenberg-6295 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.