I have a simple list that I would like to display as a crosstab.
The calculations have already been done in the SQL so no aggregation is needed.
Everything displays in the list but the counts will not display in the crosstab.
I tried setting the Aggregate & Rollup Aggregate functions to "none" but that doesn't help.
I've attached a file showing an example of the list output and the crosstab output.
Any suggestions ?
Thanks.
Is the Usage property on NC_CNT set to "Fact" in FM?
Sorry I forgot to mention, this report is using native SQL, no FM.
Try setting the Aggregate Function to None and the Rollup Aggregate Function to Total. Should work.
Yes, that worked! Thank you so much.
I guess I don't understand the Rollup Aggregate function.
Do you mind explaining why it worked? What is it totaling?
CognoidJay's solution worked for me. Can someone explain why this combination of Aggregate Function and Rollup Aggregate Function settings works as expected? Seems non-intuitive to me.