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"));
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"));