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

ramireddy · ‎06-29-2016

Hi,

There is a report type "Multilevel Pivot". Can you try that? But this report type is not available in earlier versions. with "Pivot type" reports, you can't have more than 1 row/column levels.

guruvareddy · ‎06-29-2016

Is it possible to create a pivot table in Performance Anlytics

ramireddy · ‎06-29-2016

Check by changing widget properties:

Type: breakdown

Visualization: Pivot scorecard

Pivot breakdown: field you want to groupby

guruvareddy · ‎06-29-2016

i need to create table in Performance Analytics that is 7rows and 12 columns in the table.