pivot tables

L

leo

i've created a pivot table that shows sales by month of a
product. is there a way to have the pivot table only
display the month in which cumulative sales sales went
over a certain level? i know i can do a running balance in
the pivot table.

for instance if sales were

jan feb march
$5 $10 $15

i want the pivot table ony to show feb which is the point
at which sales hit the $10 level

thx, leo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top