I have a pivot table where I’d like to have 2 fields in the Row dimensions, but they’re at the same granularity. For example, if this is some product data, the two fields are Product SKU and Product ID. They are unique to each other and to each product. I want to have both fields in the pivot table to appear side-by-side before the cells with aggregated data, but having both fields as dimensions creates another row to display the second dimension, and this ends up doubling the length of the table, vertically.
The only way around this I could think of is concatenating a field into a calculated field, so I created “Product SKU + ID” which is just concat({PRODUCT_ID}, ' - ', SKU).
Is there a way to have multiple row dimensions without creating the extra rows?
Hi @maat,
If I understand your requirement accurately; no I do not believe this is possible within Quick Sight. When working with the pivot tables, each time you add a field to the rows section, it’s going to create a hierarchal layout based on the order of your ‘row’ fields.
This could be dependent on your setup (so if you’d like; (feel free to include a screenshot that helps show your desired output) you could try switching the pivot options, as those are the only way to adjust the layout that’s presented.
Following up here as it’s been a while since last communication took place on this thread; did you have any additional questions regarding your initial post?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Since I have not heard back further, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.
