Placement of Values in Pivot table

[#1]

Hi All,

I have attached an Excel which has sample values like my application. I have 3 levels highlighted in column A. Can I achieve this in PIVOT or STRAIGHT TABLE. Currently it pivots one next to the other, I want it one below the other is that possible.? I am looking at it in this way because I want the values to be aggregated at all 3 levels. Thanks !!!

[sunny_talwar · Accepted solution]

I think the attachment did not come through. Can you reattach?

[#3]

Hi

Guess the attachment did not come through. I am resending it.

Thanks

[#4]

Hi Sunny,

Here is the attachment

Many Thanks

[#5]

Hi Sunny,

Hope you got the attachment.

Thanks in advance

Priya

[sunny_talwar]

You can use 'Indent Mode' on the Style tab of the Pivot table. Look here for similar disucssions:

Creating a Tree view in a Pivot table | Qlik Community

Using tree structure in the pivot table?

Create TreeView in Pivot Table | Qlik Community