[Last Call] Learn how to a build a cloud-first strategyRegister Now

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

crosstab query

guys, how come my cross tab query cannot work below? i've got a value, row and column field.
crosstab1.png
crosstab2.png
0
developingprogrammer
Asked:
developingprogrammer
1 Solution
 
als315Commented:
You can have many Row Headings, but you had to have one (only one) Column Heading and one (only one) Value
0
 
developingprogrammerAuthor Commented:
I see als315. Then the better option is to export to excel then pivot cause it's more robust. Thanks!!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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