nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

multilevel grouping

kumbare · 2016-09-07T16:11:21+00:00

Hi team, i want to generate report as shown in below details with three group level information. Group 1 Sub Group 2 Sub group 3 Group 1a Sub Group 2a Sub group 3a Group 1b Sub Group 2b Sub group 3b …

kumbare

Hi team,
 
i want to generate report as shown in below details with three group level information.
 
 
Group 1

Sub Group 2 Sub group 3
 
Group 1a

Sub Group 2a Sub group 3a
 
Group 1b

Sub Group 2b Sub group 3b
 
 
can you give me any example for such grouping ?

Find more posts tagged with

Comments

pricher

Hi,
 
Can you send some sample data (in a CSV file) and how you want the data organized based on this data? It's not exactly clear to figure out from your mock up.
 
Regards,
 
P.

kumbare

Hi,
 
I dont have CSV with me but you can refer below structure.
 
 
 Product 1

Type 1 | Type 2

Series No | Price | Series No | Price 
 Product 2

Type A | Type B

Series No | Price | Series No | Price
 Product 3

Type N | Type M

Series No | Price | Series No | Price
 
 
Thank You

pricher

A combination of a table and a crosstab can reproduce the sample structure.
 
Assuming the following data set:
<pre class="_prettyXprint _lang-">
Product,Type,SeriesNo,Price
Product 1,Type 1,Series1,1
Product 1,Type 2,Series2,2
Product 2,Type A,SeriesA,3
Product 2,Type B,SeriesB,4
Product 3,Type N,SeriesN,5
Product 3,Type M,SeriesM,6
</pre>
You can create a data cube with the following structure:

kumbare

Thank you for quick reply.
 
I have only one issue left in that. I dont want to show summary for fields.
 
intead of that it should show actual values from CSV.
 
lets add series code to csv
 
Product,Type,SeriesNo,Price, code Product 1,Type 1,Series1,1, ABC Product 1,Type 2,Series2,2, XYZ Product 2,Type A,SeriesA,3, MNO Product 2,Type B,SeriesB,4, PQR Product 3,Type N,SeriesN,5, ABC Product 3,Type M,SeriesM,6
 
Please guide me on this.

pricher

The solution is based on a dataset where each combination of Product and Type is unique. In other words, there can only be one Series and Price for each combination of Product and Type. In that case, the summary field will always summarize one value (in my example, I used the FIRST function.) If you have a new column, Code, then treat is as a new "summary" field and add it to the crosstab.
 
P.