Hi!

[#1]

GroopABC	product	ABC
А	product 1	А
С	product 2	С
	product 3	С
	product 4	С

[#2]

need help.

possible to make the pivot table in a file, as in Table Excel?

[MK_QSL]

Have you tried straight table?

[#4]

yes, but without result.

[sundarakumar]

Am not clear about your requirement.

Please find the attachment.

Is this what you need?

[jerem1234 · Accepted solution]

Not sure if this is what you're looking for. If it doesn't help, try to explain what you are trying to achieve. Grouped your products in loadscript rather than in chart. Are you trying to group your products based on the previous product's share?

PFA

Hope this helps!

[#7]

I need to create the summary table. the first column is groups of product: A, B, C.

we open them, we receive goods which belong to this group.

that is we have 4 product, one treats group 'A', the others group 'C'.

we open group of product 'A' we will see one goods, we open group of goods 'C' we will see all other products (2,3,4)

that is from these 3 columns to make 3 groups (A, B, C) - (it is our first column)

[#8]

thank you very much

[#9]

small question.

Can we prescribe rules PivotTable properties (through expressions and calculated measurement)?

[jerem1234]

Not sure what you mean by rules, could you explain a little more? If what you are asking is if it can be done using expression and calculated dimensions, then sure, there might be a way. The last two columns, product and ABC, would be easy to do. But for the first column of GroupABC, since there is no link between ABC and product, it would be hard and probably won't get you the table you want. The best way is to do in loadscript, so there is a link between ABC and product and then you can use it as a dimension and get only the products for that group.

Hope this helps!