CrossTab 2 Sum's next to eachother
Ok, a bit of a double question
This is what i would like to see
Day 1 Day 2
Day 3 Day Totals
Building1 Sum(A) Sum(B) Sum(A) Sum(B) Sum(A)
Sum(B) Total(A) Total(B)
Building2 Sum(A) Sum(B) Sum(A) Sum(B) Sum(A)
Sum(B) Total(A) Total(B)
Building3 Sum(A) Sum(B) Sum(A) Sum(B) Sum(A)
Sum(B) Total(A) Total(B)
And very wonderfull it would be that for example i could supress the detail
printing of column B, just print tot total.
I now, it can be done by variables etc, but in a simple crosstab ????
This is what i would like to see
Day 1 Day 2
Day 3 Day Totals
Building1 Sum(A) Sum(B) Sum(A) Sum(B) Sum(A)
Sum(B) Total(A) Total(B)
Building2 Sum(A) Sum(B) Sum(A) Sum(B) Sum(A)
Sum(B) Total(A) Total(B)
Building3 Sum(A) Sum(B) Sum(A) Sum(B) Sum(A)
Sum(B) Total(A) Total(B)
And very wonderfull it would be that for example i could supress the detail
printing of column B, just print tot total.
I now, it can be done by variables etc, but in a simple crosstab ????
This discussion has been closed.
Comments
Sorry, but the crosstab value dimensions print one above the other, rather
than side by side.
The crosstab.AfterCalc event can be used to modify the Crosstab.Matrix prior
to it being rendered. This provides some control over deleting columns and
rows.
--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
wishlist of the crosstabs.
Control over the direction of the columns ???