Recent content by mtr08004

Thanks!!! I’ll be poking at this on Monday.

Check that... I generated a new error. The way it is in the workbook does not subtotal per month. Which was my original issue. Fixing the format solved half the problem. I not get a real number but its for the entire data set not the sliced one. Sorry for the confusion. I've been working too...

Yes. The data was formatted as general instead of date. Once I washed that column all worked fine. Thank you for the response.

Ok. So the error must be in my spreadsheet from finance. My math seems to work in the washed version that I just created here.

Hello everyone. This really has me stumped. I recently started handling data in Excel using structured tables. I believe it would useful to create a working dashboard for customer entry and sales data. I dropped my data in which included: Opportunity Name OWNER Business Line...

anyone?

Does anyone know how I can display all of that data with a certain field assiocated to it from another worksheet? Example, I want to display all of the projects with an "active" flag, owned by a certain person in my "dash board" sheet. I have a main data dump from our corporate system with ALL...