Cross tab issue

philky001

Board Regular
Joined
Jun 8, 2005
Messages
111
I'm doing a very simple report. I have a bolean field that I converted to 0 and 1 using sql CASE.

In the virtual view is defined as an Int.

When I create the Crosstab, the values column is the column RevSup that I converted to 1 and 0.

For some reason is not summing all the records that it should. It sees one of the same event, displays one and ignores the rest. I know I have 16 records with a value of 1. The crosstab only counts 11. I'm adding an image of the crosstab and an image of the pivot table in excel.
 

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,211
Hello, it is nigh impossible to advise based on the description given. Maybe best to re-try to explain the situation.

Does a different query, I'm thinking a simple SELECT query, reveal which data is not reporting as expected? Or at least confirm the result.
 

Forum statistics

Threads
1,085,815
Messages
5,386,051
Members
401,980
Latest member
chaithanyakrishnagck

Some videos you may like

This Week's Hot Topics

Top