VoV Single Summary

A Single Summary VoV combines grouped and aggregated summary results from multiple Views into a single result.

For example, if two Views are both grouped by date, the Single Summary VoV can combine the summary results from both Views for matching dates.

Single Summary Requirements

Views used in a Single Summary VoV must use compatible grouping structures.

The Views must have:

• The same number of groupings
• The same number of grouping levels
• Matching grouping data types
• The same grouping order

Note: VoV Single Summary does not work with Advanced Queries.

Creating a Single Summary VoV

Step 1: Open the VoV Builder

Open the VoV Builder from VDM.

Step 2: Select SingleSummary

In the VoV properties, set VoV Option to SingleSummary.

Step 3: Add the Views

Select Add View and add each View that will be included in the Single Summary VoV.

For this example, the following Views are used:

• Sales_By_Date.vdm
• Returns_By_Date.vdm

Both Views use one Date grouping level.

Step 4: Review the View Settings

Confirm that each View has the correct Connection Profile and return type configured.

For the example Views:

Sales_By_Date.vdm

• Group: OrderDate
• Count: SaleID
• Returned Name: Sales Count
• Sum: SalesAmount
• Returned Name: Total Sales

Returns_By_Date.vdm

• Group: ReturnDate
• Count: ReturnID
• Returned Name: Return Count
• Sum: ReturnAmount
• Returned Name: Total Return Amount

Step 5: Save the VoV

Select Save and save the VoV.

For this example, the VoV is saved as:

SingleSummary.vdmv

Running the Single Summary VoV

Open the saved VoV in VDM and run it.

VDM executes each View included in the VoV and combines the grouped summary results.

Example Results

In this example:

• Sales_By_Date.vdm returns sales totals grouped by date.
• Returns_By_Date.vdm returns return totals grouped by date.

When SingleSummary.vdmv is executed, the results from both Views are returned together.

Where both Views contain data for the same grouped date, the sales and return summary values appear on the same result row.

For example, 1/3/2026 contains data from both Views, so the row includes the Sales Count and Total Sales along with the Return Count and Total Return Amount.

If a date contains sales activity but no return activity, the return fields for that row are blank.

Related Articles

• VoV Overview
• VoV Builder Overview
• VoV Dataset
• Rebuild VoV
• Change ViewPath

Download Sample Views

The following sample files are used in the examples throughout this article: