Regarding enabling sub topics

[#1]

Hi everyone,

                    Here is an issue.

      Suppose I want to display "Total " and in the next column "10"

          Such that clicking on will display additional rows... for eg.

          Total         10

          a               2

          b               5

          c               3

     what can I use??

     Again I do not want additional Columns.. I need additional rows

[#2]

I think this can be achieved by playing around in pivot table, not sure thought. Can you share a sample app?

[tresesco]

Have you tried hierarchy?

[#4]

actually i want some thing like this:

1     a         10

2     b         15

3     c      30

4     d          5

so when i press the sign beside 'c' the output is:

1     a     10

2     b     15

3     c     30

       i      15

       ii      5

       iii     10

4     d     5

[Peter_Cammaert]

Plain pivot table does this by itself:

I probably missed something?

Yes I did. Should have read your post in its entirety. Below is the same pivot, now with Style->Indent activated. If you only keep the first dimension label, the pivot may appear to have only one column.

The values aren't properly aligned. But that can be fixed.

Is this an acceptable compromise?

[sudeepkm]

You may use a drill group with second and third fields and present them in a Pivot table.

Whenever user selects a value the next level should show. Please take a look at the attachment.