Excel PivotTable from Cube: How to get a flat table?
I'm importing data from a SQL Cube and have several row labels I'd like to show. Is there a w开发者_开发知识库ay to NOT have the hierarchical view? (aka no plus signs for the first row values, and instead show the second row label's value next to the first row labels, etc.) I'd like to see ALL data without it being hidden or aggregated together.
Figured it out...
It's under PivotTable Tools > Design > Report Layout > Show in Tabular Form
精彩评论