DSum in What if Data Table

[ChristineRTP]

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]

Why don't you use a totals query rather than DSUM?

 

[ChristineRTP]

Never done a Totals query will try to look it up?