BI Publisher CrosstabTotal
Another request to get crosstab total in BI Publisher from forum.
Forum post
Just we need to map the column and row in old way.
Note: this is crosstab and latest BIP has the functionality of PIVOT table, which is more powerful than this.

Forum post
Just we need to map the column and row in old way.
Note: this is crosstab and latest BIP has the functionality of PIVOT table, which is more powerful than this.


Comments
I have a similar requirement and this blog helped a lot.
I have one question, though: My report has PERIOD_NAME for column headers (instead of NAME), and PERIOD_YEAR as the break (instead of RESOURCE_NAME). I want ONLY the PERIOD_NAME columns to appear when they correspond to the PERIOD_YEAR. Currently my report is showing blank columns and headers for the periods that do not belong withing the year, but I need them to not appear at all.
How can I accomplish this?
Thank you very much!
Suzanne
How to add if condition?