DSum in What if Data Table

ChristineRTP

New Member
Joined
Oct 29, 2009
Messages
12
I have a list of products and units. I used the DSUM function to sum the specific product units. I place the product name in the criteria field of the DSUM function. I have 10 DSUM funtions with 10 different criteria areas and a different product name. Wanted to see if I could place the DSUM function in a what if data table and then put the product name down the rows and create a data table. The table just gives me back the product names not the DSUM answer? Thanks for your help.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,409
Office Version
365
Platform
Windows
Why don't you use a totals query rather than DSUM?
 

Forum statistics

Threads
1,085,989
Messages
5,387,127
Members
402,045
Latest member
Hidalgo

Some videos you may like

This Week's Hot Topics

Top