Filter pivot table conditionally

Question

I need to make a pivot table of sales by cities. How can I filter it such that for Toronto and Montreal it will show sales > 50K and for other cities sales > 25K?

score 1 · Accepted Answer · answered Oct 31 '13 at 16:34

1

You'll need to adjust your source data to include a new column for "filtered" values. That column will have a formula to include your criteria. For example:

=if([city name]="Toronto",if([value]>50000,[value],if([value]>25000,[value],0)),0)

Then in the pivot table you use the new 'filtered value' column and filter out anything that is 0.

answered Oct 31 '13 at 16:34

guitarthrower

5,624
3
29
37

That's what I needed. Than you. – Lukasz Nov 04 '13 at 21:52

Filter pivot table conditionally

1 Answers1