Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 96
  • Last Modified:

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

Pivot Screen printDatabase1.accdb
0
pdvsa
Asked:
pdvsa
  • 3
  • 2
1 Solution
 
pdvsaProject financeAuthor Commented:
its 2010 format.  I dont think 2013 supports pivots.
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
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.
0
 
pdvsaProject financeAuthor Commented:
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
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Add an extra column in the query, and use that column in the crossquery.

DisbursementAmountWithDate: IIF(ISNULL([Actual Funded Date]),0,[Disbursement Amount])
0
 
pdvsaProject financeAuthor Commented:
Oh I see what you are doing. That makes sense.  

Thank you Philip
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now