Hello everyone,
I have a crosstab in an active report, and it runs fine when numbers are summarized at the bottom. But we want to see the total numbers in the first line. I tried to drag the summary up, and then the summary is empty. Please see attached for the crosstab I need. Any suggestion will be appreciated.
Thanks!
By the way, the summary I use is "Total" in "Summarize in Output" in the lower part of the list. The numbers will be not empty if the summary function is from "Total" in the upper part, but these total numbers cannot change with filtering.
Quote from: farlein on 24 Mar 2015 10:17:20 AM
By the way, the summary I use is "Total" in "Summarize in Output" in the lower part of the list. The numbers will be not empty if the summary function is from "Total" in the upper part, but these total numbers cannot change with filtering.
Sadly, if you are filtering the crosstab and using the "Summarize in output" Total summary, it has to go at the end. I don't believe there is any way around this.
MF.
Thanks for your prompt reply, MF! I guess we can live with summary at the bottom.