Link to home
Avatar of pdvsa
pdvsaFlag for United States of America

asked on

Pivot Subtotal

Experts, I have a pivot as shown in the pic.  I need a subtotal for [Actual Funded Date].  I right click and add click subtotal but it is not what is expected.  

I have attached the db query.

thank you

User generated imageDatabase1.accdb
Avatar of pdvsa
pdvsa
Flag of United States of America image

ASKER

its 2010 format.  I dont think 2013 supports pivots.
Avatar of Phillip Burton
Phillip Burton

I don't understand the question.

Every line is a subtotal for "Actual Funded Date".

You can get subtotals for "Expected Funding Date", but you've got subtotals already.

Additionally, in the database you have posted, I can't see how you got to the graphic that you have posted - the right fields don't seem to be there.

Can you please post the database with the query/form that you show above as part of the database, and maybe explain your problem more.
Avatar of pdvsa

ASKER

Philip,

How can I sum for Actual Funded Date for where the dates are not null?  

You can delete columns if need be in the qry to match the pic. I am only interested in the Disbursement Amount

Let me know if not clear
Thank you
ASKER CERTIFIED SOLUTION
Avatar of Phillip Burton
Phillip Burton

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of pdvsa

ASKER

Oh I see what you are doing. That makes sense.  

Thank you Philip