How to conditionally hide headers in pivots (created using crosstab function) created in RTF?
Hi.
I have created a pivot table in RTF.
The issue is the headers in the pivot table may have blank data & therefore it shows up in the report as blank.
Example below (circled area should not show up in the report; i.e. there are the fields I want to hide.
I cannot remove these in the data model as it will remove other data I need for this report.
I have tried editing the crosstab function without any luck. Also I am not too savy when it comes to understanding or editing the crosstab function.
Thanks.