pivot table in report. how can i select the multiple fields in report row level.

guruvareddy · ‎06-29-2016

when i am creating a pivot table in report. how can i select the multiple fields in report row level.is it possible to create pivot table in performance analytics.

ramireddy · ‎06-29-2016

I don't think you can do it in the same format(Unless, you create a UI page and use your own aggregation queries, which is not recommended at all). Using Performance analytics, You can do like below.

1. Ensure for all these metrics, You have indicators with breakdown as "Application", if they aren't exists already and create indicators for them.

2. Then, you can create a new dashboard, add a tab in the dashboard, For the tab add content. While adding content, you can find all these indicators in "breakdown" section. Add them to dashboard.

In the end, you will have 10widgets in same window displaying, these detail.

View solution in original post

ankit_sharma487 · ‎02-13-2017

hi Gaurv, now we have Multilevel Pivot option also and you can select up to 3 fields on row and column level

kritesh · ‎11-29-2018

If you are finding difficulty in excel file and you are not getting proper solution then you can consult with Expert Trainer. YOu can also learn new tricks and get proper knowledge of excel skills with the help of advance excel training course in Noida.