OWC10 How do I exclude a value?

D

Dave Hewes

I am converting excel pivot tables to the web.
How do I exclude a value?

My current code (JS) for everything else is as follows:

vwView.TitleBar.Caption = "Available Box Distributionâ€
vwView.FilterAxis.InsertFieldSet(vwView.FieldSets("Size"));
vwView.ColumnAxis.InsertFieldSet(vwView.FieldSets("Status"));

Include all Status
Exclude Status "R" Value here
Exclude Status "T" Value here

vwView.RowAxis.InsertFieldSet(vwView.FieldSets("Market"));
vwView.RowAxis.InsertFieldSet(vwView.FieldSets("Region"));
 

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