ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: 徐雪峰 on July 26, 2020, 08:38:04 am

Title: can tree grid be pivoted?
Post by: 徐雪峰 on July 26, 2020, 08:38:04 am

can tree grid be pivoted?
for example set the colgroup.

Title: Re: can tree grid be pivoted?
Post by: paramvir on July 27, 2020, 08:38:33 am

Column grouping: columns can be grouped for treegrid similar to normal grid with use of nested colModel.

Pivot: So far treegrid has never been pivoted. Please share your requirement of pivoting of treegrid and I would look into it.

Title: Re: can tree grid be pivoted?
Post by: 徐雪峰 on July 27, 2020, 04:24:45 pm

my goods data like under code:
goods_brand    goods_panentclass   goods_sonclass goodssonclass1 goodssonclass2...  salseamount   salesDate
BrandA             ClassA                    ClassA_a           ClassA_a_1       ClassA_a_1_1       10000            2019-01-01
BrandA             ClassA                    ClassA_a           ClassA_a_1       ClassA_a_1_2       10000            2020-01-01
BrandA>ClassA>ClassA_a>ClassA_a_1....
i want get every goods class's  summay of sales money. and summed by year,for example 2019 ,2020.
the class of goods is a tree structure.  every level summay is be hoped to sum.
are you have some good suggestion?

Title: Re: can tree grid be pivoted?
Post by: paramvir on July 27, 2020, 10:57:39 pm

That kind of data is used for row grouping, and yes row grouping can be converted into pivot grid as shown in the examples.