crosstab no aggregation needed

[busterbbg]

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.

[AnalyticsWithJay]

Is the Usage property on NC_CNT set to "Fact" in FM?

[busterbbg]

Sorry I forgot to mention, this report is using native SQL, no FM.

[AnalyticsWithJay]

Try setting the Aggregate Function to None and the Rollup Aggregate Function to Total. Should work.

[busterbbg]

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?

[psrpsrpsr]

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.