I have a chart and columnar table object in the view, that work perfectly. But I also have a requirement to show some of the data in a crosstab (pivot table) format. Is this possible and if so how do I go about doing this?
I solved this by creating another chart sheet object using the pivot sheet object. Then it's just a few steps to make it look like I wanted. Had to move dimensions and expressions around manually but it worked!