Conditinal formating in pivot table

vishal chitrala 51 Reputation points
2021-07-14T18:20:33.613+00:00

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 Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,367 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,939 questions
0 comments No comments
{count} votes

Accepted answer
  1. Emi Zhang-MSFT 30,041 Reputation points Microsoft External Staff
    2021-07-15T02:21:38.213+00:00

    Hi @vishal chitrala ,
    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.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Herbert Seidenberg 1,191 Reputation points
    2021-07-15T02:38:37.917+00:00
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.