1 - In the crosstab table example below how would I remove the #Name (from CrossTabB)? This occurred because there was data matching the selection criteria and now there is not. I would like to make a 0 show up. I am using a cross tab query.
A related question which may have the same answer….
2 - Also, in the example below the first column (Submit column) in the last table (Crosstab C) is not displaying (i put the word "blank" to identify it for you - i want a "0") because there is not and never has been data for that combination of values. How can I force a zero so that column would contain all zeros?
Thanks again for all your help!!
(apologies about the layout of my data, but i dont have access to post an image for you
CrosstabA Submit Analyse Test Total
ML 2 1 3 6
TF 0 1 3 4
CrosstabB Submit Analyse Test Total
URGENT #Name? 1 4 5
HIGH #Name? 2 2 4
LOW #Name? 8 0 8
CrosstabC blank Analyse Test Total
GPCx blank 6 1 7
GPCy blank 2 3 5
A related question which may have the same answer….
2 - Also, in the example below the first column (Submit column) in the last table (Crosstab C) is not displaying (i put the word "blank" to identify it for you - i want a "0") because there is not and never has been data for that combination of values. How can I force a zero so that column would contain all zeros?
Thanks again for all your help!!
(apologies about the layout of my data, but i dont have access to post an image for you
CrosstabA Submit Analyse Test Total
ML 2 1 3 6
TF 0 1 3 4
CrosstabB Submit Analyse Test Total
URGENT #Name? 1 4 5
HIGH #Name? 2 2 4
LOW #Name? 8 0 8
CrosstabC blank Analyse Test Total
GPCx blank 6 1 7
GPCy blank 2 3 5