I'm trying to use DSUM on a [pt]*[/pt] pivot chart and it returns #Value!. When I copy the Pivot Chart(values only) to a blank sheet the DSUM function works fine.
I can't seem to figure out why it doen't work with a pivot chart, yet when everything is placed at the exact place on another sheet w/o the pivot table formatting it works fine.
I attached a sample workbook so you can see my problem, any help would be appreciated.
Couldn't attach it, too big so...