How to add additional dimensions to a report in bulk using Ad Hoc

[kateyt59506756]

I have a report in ad-hoc that is pageviews by page name. I know I can drag another dimension (say Language) and drop it on the page name, so I can see the page name, broken down by language. What I can't seem to figure out is how to do a bulk drag and drop - that is, have the "Language" variable be applied to every page name. Right now I can only drag and drop one by one - there has to be an easier way.

Thanks everyone.

[Urs_Boller]

select all items (shift or ctrl + click) which you want to break down (blue marked) and drop the desired metric on on of the marked items ...

[kateyt59506756]

Thanks for your answer, however I tried doing this and the secondary dimension only gets attributed to the line item where it was dropped.

[Urs_Boller]

have you selected more than one row (blue shadow on the selected rows) and did you drop the metric on one of them? or did you try with another browser? i have no problems with chrome ...

[Urs_Boller]

and here is a video that might help you:

Dimensions in Analysis Workspace - YouTube

[Gigazelle · Accepted solution]

Using the Table Builder allows you to create a report that automatically breaks down every line item.