Hi
I'm pulling data from 2 different dimensions in a cube. Region and Customer Class/Customer. Im using sectional headings for the Region and Customer class. Customer is my row. I am suppressing all rows with no data and also set the No Data content property.
When I run the report and filter on Customer class, the Customer class + the cross tab headings are still getting displayed even tho there are no Customer rows. How to suppress the empty crosstabs from displaying? I only want to show the Customer Class if there are customer rows.
This is what it looks like:
Region: XXX
--------------------------
Customer Class: ZZZ
--------------------------
Current Month Prior Month
Sales Sales
Customer Class: YYY
--------------------------
Current Month Prior Month
Sales Sales
Customer A 123.00 456.00
Customer B 123.00 456.00
Thank you in advance.
When columns are suppressed, the sectional headers are still getting displayed. Is there a way to only show the crosstabs with rows?
I want Customer Class YYY to show.
Region: XXX
--------------------------
Customer Class: ZZZ
--------------------------
No data available.
Customer Class: YYY
--------------------------
Current Month Prior Month
Sales Sales
Customer A 123.00 456.00
Customer B 123.00 456.00