Row selections

[divapaxo]

Hi All

could someone please advise how i can get my pivot table to only
return rows where column A contains the wording TOTAL

thank you

 

[xenou]

Hi. Welcome to the Board.

A pivot table will not work well with substrings. By "contains the word TOTAL" do you mean
1) the value of the Cell is TOTAL or
2) that the value of the cell is possibly TOTAL DUE or TOTALQTY, or other variations of TOTAL.

If the answer above is 1), then you want to create a page field. You can then filter the pivot table to display only the TOTAL items.

If the answer to the above is 2), then you want to create a column in your source data that you can then use as a page field. If possible:
Insert a new column B
Enter the formula in Cell B2 =IF(ISERROR(SEARCH("total",A2)),0,1)
Search() is not case-sensitive. You can now use this column as a page field to display only those rows where the formula above returns a 1 (meaning it found "Total" somewhere in the A Cell next to it.

Hope this helps.