Compact form pivot tables

[ImSoHappi]

Description

Hi!!, I am working in pivot tables and there is an option in excel that allows displaying the labels in the same column called compact form or outline form, I don't know if I am confusing this option with the compactData in excelize, are they the same? Is there any way that excelize does The same? I am using multiple fields for the rows, and it is putting them together but I need these rows not to appear separately and from what I see, compactData does not seem to be what I need.

***I did not know where was the right place to expose this

Describe the results you received:

Describe the results you expected:

Output of go version:
go version go1.17.1 windows/amd64

Excelize version or commit ID:
2.4.1

[xuri]

What source range data look like, could you provide an spreadsheet attachment without confidential info?

[ImSoHappi]

@xuri I leave you an example of excel with which I am working, the columns and the rows must be with the compact mode, according to the photo of the result that I expected

***info are randomly generated

test.xlsx

[xuri]

Hi, I've added support for setting compact and outline for the pivot table, please upgrade to the master branch code, and this feature will be released in the next version. Now, you can add pivot like this:

package main

import (
    "fmt"

    "github.com/xuri/excelize/v2"
)

func main() {
    f, err := excelize.OpenFile("test-2.xlsx")
    if err != nil {
        fmt.Println(err)
        return
    }
    if err := f.AddPivotTable(&excelize.PivotTableOption{
        DataRange:       "Sheet2!$A$1:$G$21",
        PivotTableRange: "Sheet2!$I$3:$S$68",
        Rows: []excelize.PivotTableField{
            {Data: "ROW1", Compact: true, Outline: true},
            {Data: "ROW2", Compact: true, Outline: true},
            {Data: "ROW3", Compact: true, Outline: true},
            {Data: "ROW4", Compact: true, Outline: true}},
        Filter: []excelize.PivotTableField{
            {Data: "COL1"}},
        Columns: []excelize.PivotTableField{
            {Data: "COL2"}},
        Data: []excelize.PivotTableField{
            {Data: "VALUE", Name: "Promedio de Of/Prod Simple", Subtotal: "Sum"}},
        RowGrandTotals:      true,
        ColGrandTotals:      true,
        ShowDrill:           true,
        ShowRowHeaders:      true,
        ShowColHeaders:      true,
        ShowLastColumn:      true,
        CompactData:         true,
        PivotTableStyleName: "PivotStyleMedium9",
    }); err != nil {
        fmt.Println(err)
    }
    if err := f.SaveAs("Book1.xlsx"); err != nil {
        fmt.Println(err)
    }
}