3 Replies Latest reply: Dec 5, 2013 9:02 AM by Marcus Sommer RSS

    Pivot Table / Sub Headers

      Hello together,

       

      is there any possibility to get sub-headers into a Pivot or Straight-Table?

      I have a table with a lot of articles, which are grouped in different categories.

      The goal is to get a sub-header between every change of categories with the name of the following category.

      Maybe it is possible to use sub-totals with custom (dynamic) labels?

       

      it should look like:

       

      | art. nr. | description |

      |         Fruits             |

      |  123    | Bananas    |

      |   234   | Apples       |

      |      Vegetables        |

      |  321    | carrots       |

      |  214    | potatoes    |

       

       

      Does anyone have an idea?

       

      Thanks in advance

      Björn