Cross Tab Query

P

paulcherianc

Registered User.

Local time

Yesterday, 23:15

Joined

Aug 15, 2013

Messages

86

• Nov 9, 2016

• #1

Dear Experts!

Can i omit one column value and make a total in cross tab query. I have attached a sample screen shot for better understanding. From the column heading i need to get a total of all columns starting from "CROMPTON" till "TTC". Total should not include the "QDVC" Count. Could anyone tell me how it works!:banghead:

 

Attachments

• 
  crosstab.JPG

  25.2 KB · Views: 202

Ranman256

Well-known member

Local time

Today, 02:15

Joined

Apr 9, 2015

Messages

4,344

• Nov 9, 2016

• #2

Q1 should have all records filtered you want to see.
Q2 is the Crosstab query using Q1.

 

stopher

AWF VIP

Local time

Today, 07:15

Joined

Feb 1, 2006

Messages

2,395

• Nov 9, 2016

• #3

Ranman256 said:

Q1 should have all records filtered you want to see.
Q2 is the Crosstab query using Q1.

Click to expand...

I would say its the other way round. Q1 is the crosstab, Q2 is based on Q1 and includes new columns that sum specific columns created in Q1.