1

When I am analyzing data/information, I usually use pivot function of Excel to have a better view of the voluminous data that I have. I use the Tabular Format as the report layout and just click on fields that are relevant for my analysis.

However, the tabular format shows/arranges the fields in a horizontal manner. Is there any way to present them in a vertical manner?

Let me show you an example:

When you select the following fields in field list (see screenshot below), the following will be the result:

Pivot Field Selection and Pivot Results

I wanted to present the fields in vertical manner, like this one:

Desired Pivot Result

How is it possible to achieve it?

  • What would that look like? Mock up an example manually and post a screenshot – teylyn Oct 6 '16 at 3:21
  • hi teylyn, I had updated my post. – Frances Ouano Ponce Oct 6 '16 at 4:36
  • Have a look here, did you followed the steps there and still couldn't achieve what you need? – Máté Juhász Oct 6 '16 at 5:24
  • Hi Mate. I think this would suffice. Thanks for the help. – Frances Ouano Ponce Oct 9 '16 at 5:56
2

Once you've added more than one fields to the "Values" part of the pivot table, a field called "Values" is automatically added to "Columns", just move this field to "Rows".

enter image description here

|improve this answer|||||
  • Nice. +1 I removed my false claim. I think your solution is what the OP may be after. I'll leave my post up to illustrate the unpivot effect. – teylyn Oct 6 '16 at 6:39
0

When you drag fields into the rows well of the pivot table panel, you are creating a hierarchy.

Maybe you first need to unpivot your source data, so it does not have columns for a, b, c, etc, but these are values in a categorical column. So instead of source data and pivot like this:

enter image description here

... unpivot the source data to look like the following table. Then you can pivot like below.

enter image description here

|improve this answer|||||
  • " The order that you describe is not possible with the pivot source arranged like that" - it is possible, see my answer. – Máté Juhász Oct 6 '16 at 5:38
  • seems a little bit complicated to me. Thanks anyway. – Frances Ouano Ponce Oct 9 '16 at 5:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.