'Formatting pivot tables using the styles

I'll try to be efficient in my explanation here. Trying to format a pivot table the way I want, but I struggle understanding how the "items" in the "edit style" window works.

The tables i need will have many row labels (and many value labels, but in example only one). I typically set it up in such a way that the first row label is set up in "disposition style" while the rest is set up in "table style".

I usually looks something like this:

How it usually looks

My bees, that I cannot figure out how to do, is:

It seems like the "row subheading" items from the style edit gets repeated. The first column, which is in "disposition style", gets formatted as "row subheading 1". The next column, the first one that is in "table style" gets formatted as "row subheadin 2". Then the remaining columns alternate between "row subheading 2" and "row subheading 3", in a slightly strange way. Counting from "row info 2", it is

  1. row subheading 2
  2. row subheading 3
  3. row subheading 2
  4. row subheading 3
  5. row subheading 2
  6. row subheading 3
  7. row subheading 3!!!

For some reason the repeating does NOT happen at the last one. But if I add a 9th row label, 8 will get formatted as row subheading 2.

What I instead want is that after row info 2, every column is formatted as row subheading 3, or to not be counted as a subheading, as this is just displaying tabular data. Is there any way to achieve this?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source