Does anybody know if it's possible to select the number of rows you want for every breakdown in Workspace? For example, I have 400 rows from a prop and I need to breakdown using another one, but I need 25 rows for every item (from the 400 rows). By default it's five, I think. It's really annoying to do do it one by one.
Ok thanks asheeshp and davidj85759080 Anyway, I needed to do it in Workspace because it's much quicker than Ad Hoc or Report Builder (Data Warehouse is not even an option). I hope this functionality comes quickly to Workspace
I don't see if the workspace has a setting to set the number of rows in a breakdown. However, following Ad Hoc Analysis functionality are being moved to Analysis Workspace which can help you do this in the workspace in the future.
Build advanced queries with many breakdowns, all at once (similar to Table Builder in Ad Hoc)
Download up to 50,000 rows/breakdown from a freeform table